Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this may be:
=Avg({<DoneYear={'2013','2014','2015','2016'}, DaysFromToDate={"<=$(=vMaxDaysFromToDate)"}>}DaysFromToDate)
Try this may be:
=Avg({<DoneYear={'2013','2014','2015','2016'}, DaysFromToDate={"<=$(=vMaxDaysFromToDate)"}>}DaysFromToDate)
No nothing sorry the chart is empty
Thanks my bad your code worked like a charm.
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)
I can try explaning it, but I feel that there are better resources out there. Check this link out: The Magic of Dollar Expansions