Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use of Variable in set modifier in a Chart

I have two pie charts on my sheet where one displays information based on selections on the sheet and the other is suppose to use those selections but modify the year selection to a year that the user will select from a input box.  The problem is that when i change the value in the input box, the data in the pie chart is not updating.  Below is the expression used in the second pie chart:

 

sum

({$<week_broad_year = {"=nYearToCompare"}>} GROSS_DOLLARS)

The variable is nYearToCompare and it is set to a year (i.e. 2010).  Thanks in advance for any help.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

try: sum({$<week_broad_year = {"$(nYearToCompare)"}>} GROSS_DOLLARS)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

try: sum({$<week_broad_year = {"$(nYearToCompare)"}>} GROSS_DOLLARS)


talk is cheap, supply exceeds demand
MayilVahanan

HI

Try like this

=Sum({< week_broad_year ={$(nYearToCompare)}>} GROSS_DOLLARS)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

That fixed it.  Thanks so much Gysbert.