QlikMapsQlikMapsDocumentation for QlikView PopupsCreate a popup that shows a Bar Graph

Create a popup that shows a Bar Graph

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 a bar graph, you can modify this expression so it generates HTML that queries the Google Image Chart API. Documentation and examples for the Google Image Chart API can be found here:

The following is an example that shows a bar/riser chart based upon “Sales” by “Venue” over “Month.” It includes logic to automatically scale the axes.

=	'<font face="Arial" size="-1"><b>Venue</b> = ' & Venue & '<br>' &
	'<b>Sales</b> = ' & num(sum(Sales), '$#,###.') & '<br><br>' &
	'<b>' & Repeat('&nbsp', 30) & 'Monthly Revenue</b><br></font>' &
	
	'<img src="http://chart.apis.google.com/chart' &
	'?chbh=a' &  //bar width
	'&chxr=0,10,100' &  //axis ranges
	'&chxt=x,y' &  //visible axes
	'&chxl=0:|J|F|M|A|M|J|J|A|S|O|N|D|1:|' &  //axis labels
		if(len(min(Sales))>6, floor(min(Sales)/1000000,1)-1&'M',	
		if(len(min(Sales))>3, floor(min(Sales)/1000,1)-1&'k',	
			max(Sales)-1)) &
	'|' &
		if(len(max(Sales))>6, floor(max(Sales)/1000000,1)+1&'M',	
		if(len(max(Sales))>3, floor(max(Sales)/1000,1)+1&'k',	
			max(Sales)+1)) &
	'&chxs=0,676767,9.5,0,l,676767' & //axis label style
	'&chs=325x100' &  //chart size
	'&cht=bvs' &  //chart type = bar chart
	'&chco=0000FF' & //riser colors
	'&chds=' &
		if(len(min(Receipts))>6, floor(min(Sales),100000)-100000,
		if(len(min(Receipts))>3, floor(min(Receipts), 1000)-1000,
			min(Receipts)-1)) &  ',' &
		if(len(max(Sales))>6, floor(max(Sales),100000)+100000,
		if(len(max(Receipts))>3, floor(max(Receipts), 1000)+1000,
			max(Receipts)+1)) &  //axis scale
	'&chd=t:' &
		sum({$<LongMonth = {"January"}>} Sales) & ',' &
		sum({$<LongMonth = {"February"}>} Sales) & ',' &
		sum({$<LongMonth = {"March"}>} Sales) & ',' &
		sum({$<LongMonth = {"April"}>} Sales) & ',' &
		sum({$<LongMonth = {"May"}>} Sales) & ',' &
		sum({$<LongMonth = {"June"}>} Sales) & ',' &
		sum({$<LongMonth = {"July"}>} Sales) & ',' &
		sum({$<LongMonth = {"August"}>} Sales) & ',' &
		sum({$<LongMonth = {"September"}>} Sales) & ',' &
		sum({$<LongMonth = {"October"}>} Sales) & ',' &
		sum({$<LongMonth = {"November"}>} Sales) & ',' &
		sum({$<LongMonth = {"December"}>} Sales) &  //riser labels
	'"/>'