QlikMapsQlikMapsDocumentation for QlikView PopupsCreate a popup that shows an HTML table

Create a popup that shows an HTML table

Edit the Popup Text expression

The popup text is controlled by modifying the expression for “Popup Text” in the “Marker Properties” and “Polygon Properties” sections. If you want to create an HTML table, you can modify this expression so it generates an HTML that builds an HTML table.

=	'<table border = "1" style="width: 350px;">' &\L
		'<tbody>' &
			'<tr>' &\L
				'<td colspan="2" style="text-align:center;">' &
					'<b>' & MaxString([Account Name]) & '</b><br>' &\L
					'<b>' & MaxString([AE Name]) & '</b>' &\L
				'</td>' &\L	
			'</tr>' &\L
			'<tr>' &
				'<td style="text-align:center; font-size:13px;"><b>Accts</b>: ' &
					Num( Sum ( [Acct Count]) , '#,##0')
					& '</td>' &\L
				'<td style="text-align:center; font-size:13px;"><b>Units</b>: ' &
					Num(  Sum ( [Unit Count]) , '#,##0')
					& '</td>' &\L
			'</tr>' &\L
			'<tr>' &\L
				'<td style="text-align:center; font-size:13px;"><b>Open Opps</b>: ' &
					Num(Sum ( { $<[Status]={'Open'}>} [OPPTY Count] ) , '#,##0')
					& '</td>' &\L
				'<td style="text-align:center; font-size:13px;"><b>Closed Opps</b>: ' &
					Num(Sum ( { <[Status]={'Closed'}>} [OPPTY Count] ) , '#,##0')
					& '</td>' &\L
			'</tr>' &\L
				'<td style="text-align:center; font-size:13px;"><b>YTD Actuals</b>: ' &
					Num( Sum ( [Total Amt]), '$#,##0') &\L
					& '</td>' &\L
				'<td style="text-align:center; font-size:13px;"><b>Pipeline</b>: ' &
					Num( Sum ( [Pipeline Amt]), '$#,##0') &
					& '</td>' &\L
			'</tr>' &\L
		'</tbody>' &\L
	'</table>'