Changing Denominators

[Stars]

Is there a way to toggle between different denominators on a graph?  I don't even know how it would work....  Maybe having separate sheets and buttons connecting the sheets is the best option.

I would like to have cost graphs:

Cost per Customer

Cost per Customer

Cost per Order

The numerators are all the same, but the denominators are completely different.

[Yousef_Amarneh]

Please have a look to the below

https://community.qlik.com/t5/New-to-Qlik-Sense/How-can-i-change-a-dimension-in-a-chart-by-click-on-...

[Stars]

I like changing dimensions!  But I just need to change the denominator in my expression.

[Yousef_Amarneh]

 didn't get you, can you please give an example

[Mauritz_SA · Accepted solution]

Hi there

Make your denominator a variable and then use the variable input extension (shipped with Qlik) to change the value of the variable Customer or Order . You can then make the label of your graph/measure dependent on the value of the variable to decide whether it is 'Cost per Customer' or 'Cost per Order'.

Hope it helps.

Regards,

Mauritz

[Stars]

Yesss!  That's brilliant.  I knew there would be a way!  Thank you!!!!