This content has been marked as final. Show 3 replies
I have a requirement to show relative value totals by dimension in Qlik sense. I have a table as follows
|Company Name||Sales Total|
|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.