Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kanimozhi
New Contributor II

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

Tags (1)
1 Solution

Accepted Solutions

Re: How to use fileter in Fractile function

May be one of these:

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

or

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

2 Replies

Re: How to use fileter in Fractile function

May be one of these:

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

or

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

kanimozhi
New Contributor II

Re: How to use fileter in Fractile function

Thanks Sunny it works.

Community Browser