Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Relative value total in the bar chart using Qlik Sense

Hi Experts,

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

Company NameSales Total
Innovation  Industries50000
online Income pvt Limited70000
Entreprenette pvt Limited35000
Recycled Products pvt limited40000

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 NameRelative Sales TotalLogic to derive
online Income pvt Limited-2000050000-70000 = -20000
Entreprenette pvt Limited1500050000-35000 = 15000
Recycled Products pvt limited1000050000-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.

3 Replies

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

Try this expression:

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


talk is cheap, supply exceeds demand
Not applicable

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

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

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


talk is cheap, supply exceeds demand