https://community.qlik.com/t5/App-Development/Changing-the-value-of-a-variable-in-a-chart-code/m-p/2454804#M98352 <P>Hello! I am currently trying to think of a solution to a problem I have and am open to all suggestions.</P> <P>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.</P> <P>If you can change inside, please let me know, if not and you have other suggestions please let me know as well. Thank you.</P> Tue, 21 May 2024 15:56:22 GMT mcsmithums1 2024-05-21T15:56:22Z https://community.qlik.com/t5/App-Development/Changing-the-value-of-a-variable-in-a-chart-code/m-p/2454804#M98352 <P>Hello! I am currently trying to think of a solution to a problem I have and am open to all suggestions.</P> <P>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.</P> <P>If you can change inside, please let me know, if not and you have other suggestions please let me know as well. Thank you.</P> Tue, 21 May 2024 15:56:22 GMT https://community.qlik.com/t5/App-Development/Changing-the-value-of-a-variable-in-a-chart-code/m-p/2454804#M98352 mcsmithums1 2024-05-21T15:56:22Z https://community.qlik.com/t5/App-Development/Changing-the-value-of-a-variable-in-a-chart-code/m-p/2454828#M98355 <P>If I understand your question correctly, you could use a Measure expression like:</P> <PRE>=Sum(Sales) * if(Category = 'Fruit', $(Var), 1)</PRE> <P>-Rob<BR /><A href="http://www.easyqlik.com" target="_blank" rel="noopener">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank" rel="noopener">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank" rel="noopener">http://qlikviewcookbook.com</A></P> Tue, 21 May 2024 16:43:07 GMT https://community.qlik.com/t5/App-Development/Changing-the-value-of-a-variable-in-a-chart-code/m-p/2454828#M98355 rwunderlich 2024-05-21T16:43:07Z