topic Re: Use of Variable in set modifier in a Chart in QlikView

Use of Variable in set modifier in a Chart

Tue, 11 Dec 2012 18:17:59 GMT

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.

Re: Use of Variable in set modifier in a Chart

Gysbert_Wassenaar — Tue, 11 Dec 2012 18:20:41 GMT

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

Re: Use of Variable in set modifier in a Chart

MayilVahanan — Tue, 11 Dec 2012 18:22:08 GMT

Try like this

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

Re: Use of Variable in set modifier in a Chart

Tue, 11 Dec 2012 18:23:18 GMT

That fixed it. Thanks so much Gysbert.