3 Replies Latest reply: Jan 10, 2016 2:17 PM by Gysbert Wassenaar

# 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

• ###### 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])

• ###### 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