Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I am currently trying to think of a solution to a problem I have and am open to all suggestions.
I have a variable that I allow the user to set ($(Var)), and it affects visuals in some of my charts. I want some bars to not be affected, (multiplying the total value by the variable amount), if a certain requirement is met . I am currently thinking of changing the value of the variable to 1 inside of the chart code if the requirement is met but I do not know if you can change the value inside of the chart.
If you can change inside, please let me know, if not and you have other suggestions please let me know as well. Thank you.
If I understand your question correctly, you could use a Measure expression like:
=Sum(Sales) * if(Category = 'Fruit', $(Var), 1)
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com