topic Relative value total in the bar chart using Qlik Sense in App Development

Relative value total in the bar chart using Qlik Sense

Fri, 08 Jan 2016 03:35:01 GMT

Hi Experts,

I have a requirement to show relative value totals by dimension in Qlik sense. I have a table as follows

Company Name	Sales Total
Innovation Industries	50000
online Income pvt Limited	70000
Entreprenette pvt Limited	35000
Recycled Products pvt limited	40000

My output should be as follows when I selected first company (Innovation Industries) in the filter then the relative totals of the rest of the companies looks like below

Filter : Innovation Industries (50000)

Company Name	Relative Sales Total	Logic to derive
online Income pvt Limited	-20000	50000-70000 = -20000
Entreprenette pvt Limited	15000	50000-35000 = 15000
Recycled Products pvt limited	10000	50000-40000 = 10000

Please let me know how can i achieve this using expressions in the Qliksense. Please help me out on this.

Thanks in advance.

Re: Relative value total in the bar chart using Qlik Sense

Gysbert_Wassenaar — Fri, 08 Jan 2016 17:11:18 GMT

Try this expression:

=$(=sum([Sales Total])) - sum({<[Company Name]=E([Company Name])>}[Sales Total])

Re: Relative value total in the bar chart using Qlik Sense

Sun, 10 Jan 2016 19:01:01 GMT

Thanks Gysbert.

The expression is showing blank value. It would be great if you provide any sample to get relative value totals that can be shown in the bar chart.

Re: Relative value total in the bar chart using Qlik Sense

Gysbert_Wassenaar — Sun, 10 Jan 2016 19:17:03 GMT

You probably didn't select a company. See attached qvf