Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am not able calculate relative total based on the dimension. I have a pivot table ass follows
Company Names | Total Sales | |
---|---|---|
Company 1 | 50000 | |
| 70000 | |
Company 3 | 35000 | |
Company 4 | 40000 |
Now, I have to show relative totals of other companies when I select "Company 1" from the filter.
The output should be like this
Filter : Company 1 (50000)
Company Names | Relative Total Sales | Loic for Relative Total | |
---|---|---|---|
| -20000 | 50000 - 70000 = -2000 | |
Company 3 | 15000 | 50000-35000 = 15000 | |
Company 4 | 10000 | 50000-40000 = 10000 |
How can I achieve this in Qlik Sense expressions?
Please help me out. I appreciate the quick solution . Thanks in advance
Please don't clutter this site with duplicate discussions: Relative value total in the bar chart using Qlik Sense
If you can't wait for little more than an hour for an answer then hire a consultant to help you.