Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I have created a financial dashboard, now, I want the user to be able to change the metric value i.e. an ability to change the dollar values by dividing or multiplying it by 1000 which would further affect all the dollar values on the dashboard.
I feel I can achieve this using Actions and Buttons but since we are using an older 2019 Qlik Sense version how do I go about doing this? Is there a way to achieve this using variables/bookmarks?
Thanks,
Prerak
I don't remember exactly which features was available in that older version, but if you can use buttons to set a variable value then you can do like this:
1. Create a variable vDivisor
2. Button that sets vDivisior to 1
3. Button that sets vDivisor to 1000
4. In expressions add a division like sum(Value)/$(vDivisor)
Remember that if the expression is sum(A)+Sum(B) you need to write (sum(A)+sum(B))/$(vDivisior)
Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se
Thanks for the reply @morgankejerhag, I really appreciate it. However, the Buttons feature is unavailable in the 2019 version. Is there any other way we can achieve this?
Thanks,
Prerak