Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
yavoro
Partner - Contributor III
Partner - Contributor III

Clipping data

Hi all,

I have to exclude extremely low values from calculations. I would like to do it on fly, in the expressions, not in the load script though. 

Please have a look at the example attached. I have calls list with relevant ID, caller and value. I would like to count the number of calls by caller ignoring the first 10% of the calls of each caller that have low values.

I’m able to get it work when I have one caller selected. As you can see caller Frieals has 40 calls in total and when it’s been selected I get 36 calls (4 calls have been clipped out).

How to make it work overall, for all callers is still problem for me. Any ideas and suggestions are welcome and much appretiated.

Thanks

Y

Y.A.
1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

Check the attached file

View solution in original post

2 Replies
sivarajs
Specialist II
Specialist II

Check the attached file

yavoro
Partner - Contributor III
Partner - Contributor III
Author

Nice and simple, seems to be working as wanted. Will have to play with it further.

Thanks

Y.A.