Maintain Constant Thresholds

[#1]

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

[swuehl · Accepted solution]

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.

[#3]

You're a genius Stefan Thanks a lot.