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: 
Anonymous
Not applicable

How to use fileter in Fractile function

Hi All,

I have a field called 'IT_ElapsedDays' which contains the values '-43' .


Fractile(IT_ElapsedDays,0.8) is what my KPI expression. trying to apply the filter as below which is not worrking if(IT_ElapsedDays<>-43,Fractile(IT_ElapsedDays,0.8)).

anybody have idea to solve this issue. thanks

1 Solution

Accepted Solutions
sunny_talwar

May be one of these:

Fractile({<IT_ElapsedDays -= {-43}>} IT_ElapsedDays, 0.8)

or

Fractile(If(IT_ElapsedDays <> -43, IT_ElapsedDays), 0.8)

View solution in original post

2 Replies
sunny_talwar

May be one of these:

Fractile({<IT_ElapsedDays -= {-43}>} IT_ElapsedDays, 0.8)

or

Fractile(If(IT_ElapsedDays <> -43, IT_ElapsedDays), 0.8)

Anonymous
Not applicable
Author

Thanks Sunny it works.