Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Maintain Constant Thresholds

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

2 Replies
swuehl
MVP
MVP

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.

Not applicable
Author

You're a genius Stefan Thanks a lot.