topic Re: Select year in avg( statement Help in QlikView

Select year in avg( statement Help

Fri, 29 Jan 2016 13:17:27 GMT

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)

Re: Select year in avg( statement Help

sunny_talwar — Fri, 29 Jan 2016 17:07:28 GMT

Try this may be:

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

Re: Select year in avg( statement Help

Mon, 01 Feb 2016 07:20:53 GMT

No nothing sorry the chart is empty

Re: Select year in avg( statement Help

Mon, 01 Feb 2016 07:23:38 GMT

Thanks my bad your code worked like a charm.

Re: Select year in avg( statement Help

Mon, 01 Feb 2016 10:48:29 GMT

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)

Re: Select year in avg( statement Help

sunny_talwar — Mon, 01 Feb 2016 10:58:30 GMT

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