Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Community,
I'm looking to maintain a constant trend line (i.e. threshold) on a 1 year period of data. I was able to generate the full year average of my data with the use of aggr and avg functions. However when i click on a single month year the average changes.
I need this average trend line to hold despite selecting on a Year Month.
Thanks again in advance.
Best,
V
Use set analysis to ignore selections, like
avg({1} aggr(sum({1} Metric), [Month Year]))
to ignore all selections.
edit:
Or
avg({<[Month Year]>}aggr(sum({<[Month Year]>}Metric), [Month Year]))
to ignore selections in field Month Year.
Use set analysis to ignore selections, like
avg({1} aggr(sum({1} Metric), [Month Year]))
to ignore all selections.
edit:
Or
avg({<[Month Year]>}aggr(sum({<[Month Year]>}Metric), [Month Year]))
to ignore selections in field Month Year.
You're a genius Stefan Thanks a lot.