topic Re: Visualization & Percent of Total in App Development

Visualization & Percent of Total

jcampbell — Tue, 11 Nov 2014 16:08:49 GMT

I'm having trouble trying to get a visualization in Qlik Sense to display the percent of total. Here's what I have:

1. Dimension: Product

2. Spend: Sum({<[Mode (Trip)]={'A'}>}[Paid Fare])

This correctly displays the total spend by product in a horizontal bar chart. However, I'd like to show the percent of total spend by product. This was more obvious in QlikView but I'm having difficulty learning how to do this in Qlik Sense.

Thanks for your suggestions.

Re: Visualization & Percent of Total

JonnyPoole — Tue, 11 Nov 2014 16:20:18 GMT

Hi , in QlikView there was a 'relative' checkbox to quickly convert. In qlik sense you need to write it into the expression. Try both of the following. You'll need to format as a percent if it works too...

Sum({<[Mode (Trip)]={'A'}>}[Paid Fare])

Sum( total {<[Mode (Trip)]={'A'}>}[Paid Fare])

Sum({<[Mode (Trip)]={'A'}>}[Paid Fare])

Sum( total <Product> {<[Mode (Trip)]={'A'}>}[Paid Fare])

Re: Visualization & Percent of Total

jcampbell — Tue, 11 Nov 2014 16:23:40 GMT

That worked (first one). Thanks!

Re: Visualization & Percent of Total

JonnyPoole — Tue, 11 Nov 2014 16:25:12 GMT

cool. the 2nd one is if you have a chart with multiple dimensions (Product and something else) , it will do a percent of subtotal based on the individual product totals . good luck !