Select year in avg( statement Help

[#1]

Hi,

I wonder if somebody can help me with this avg statment. I want to chose only DoneYear 2014 - 2016. But This dose not work. I Think its some misplaced brackets.

Any ideas?

This works

avg({$<DaysFromToDate={"<=$(=vMaxDaysFromToDate)"}>}DaysFromToDate)

but When I try to put in YEAR it fails  badly

avg({<DoneYear={'2013','2014','2015','2016'}>}{$<DaysFromToDate={"<=$(=vMaxDaysFromToDate)"}>}DaysFromToDate)

[sunny_talwar · Accepted solution]

Try this may be:

=Avg({<DoneYear={'2013','2014','2015','2016'}, DaysFromToDate={"<=$(=vMaxDaysFromToDate)"}>}DaysFromToDate)

[#3]

No nothing sorry the chart is empty

[#4]

Thanks my bad your code worked like a charm.

[#5]

Hi Sunny,

Thanks for the help, can you describe what the function of the dollar sign Is in the expression I tried the help section in Qlik but cant understand it.

=Avg({<DoneYear={'2013','2014','2015','2016'}, DaysFromToDate={"<=$(=vMaxDaysFromToDate)"}>}DaysFromToDate)

[sunny_talwar]

I can try explaning it, but I feel that there are better resources out there. Check this link out: The Magic of Dollar Expansions