topic Net Total line in Qlik Sense line chart in App Development

Net Total line in Qlik Sense line chart

edelorme — Fri, 02 Oct 2015 14:01:48 GMT

I have a line chart that contains 2 Dimensions and 1 Measure. I would like to add a Total line that would be a sum of each data point. Unfortunately I can't add more than 1 measure with this chart setup. Does anyone know of a way/workaround to accomplish this?

Thanks.

Re: Net Total line in Qlik Sense line chart

JonnyPoole — Fri, 02 Oct 2015 16:54:51 GMT

Hi eric - i've resolved this kind of issue by introducing a custom dimension in the data model. It involves adding a new table in the load script that produces a 'Total' bucket alongside the values of your 2nd dimension .

If your 2nd dimension was region, and the values were NA, EMEA and APAC . Then a simple script to produce a 4th 'total' or 'all' region is as follows

RegionsForTotals:

Load

Region as Region,

Region as RegionForTotalChart

resident <existingtable>;

concatenate (RegionsForTotals)

Load

Region as Region,

'Total' as RegionForTotalChart

resident <existingtable>;

this will produce a new dimension called RegionForTotalChart which you can use to replace your existing 2nd dimension. Notice that the data model associates the individual regions with themselves, but the total is associated with all possible regions forcing the measure aggregation for the 'total' value to work across all values.

Re: Net Total line in Qlik Sense line chart

edelorme — Mon, 05 Oct 2015 15:28:25 GMT

Thanks Jonathan, I will give this a try.

Re: Net Total line in Qlik Sense line chart

kwdaniels — Tue, 26 Jan 2016 20:45:05 GMT

This worked like a charm. Thanks, Jonathan, for saving my day!

I look forward to the day when Qlik starts to build in more of this kind of basic functionality directly into Qlik Sense like they do for QlikView, with a simple "Show Total" checkbox (How to Calculate Sum of Volumes(Total) of all products for a given Market in a Line Chart ?).