Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude high value

Hi,

I calculate the Sum of AantalEenhedenBinnen per Time frame and show this in a line graph.

Since there is one day within a certain time frame the Sum of  AantalEenhedenBinnen is that high, I want to exclude this particular Date,Timeframe in my graph.

Because this particular time frame doesn’t represent normal business.

With =MaxString({$}(Aggr(Sum(AantalEenhedenBinnen),Date,Timeframe)))  i can figure out what is the value I want to exclude.

But what I actually need to know is which Date,Time frame generated this high value in order to exclude the results of this Date,Timeframe in my graph.


Regards

Ron

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

FirstSortedValue( Date, -Aggr(Sum(AantalEenhedenBinnen),Date,Timeframe) )

to get the Date.

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

FirstSortedValue( Date, -Aggr(Sum(AantalEenhedenBinnen),Date,Timeframe) )

to get the Date.

Not applicable
Author

Hi Tresesco,

Thanks for the quick and correct response.

This was exactly what I was looking for.

Regards

Ron