topic Maintain Constant Thresholds in QlikView

Maintain Constant Thresholds

Wed, 22 Mar 2017 15:01:55 GMT

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,

Re: Maintain Constant Thresholds

swuehl — Wed, 22 Mar 2017 15:05:05 GMT

Use set analysis to ignore selections, like

avg({1} aggr(sum({1} Metric), [Month Year]))

to ignore all selections.

edit:

avg({<[Month Year]>}aggr(sum({<[Month Year]>}Metric), [Month Year]))

to ignore selections in field Month Year.

Re: Maintain Constant Thresholds

Wed, 22 Mar 2017 15:23:03 GMT

You're a genius Stefan Thanks a lot.