Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
MRWaughsome
Contributor
Contributor

Fractile IF Condition

Hello,

I am attempting to add an FRACTILE function with IF expression to the Qlik Editor script but it always give me an invalid expression error:

Below is the expression 

FRACTILE(IF(Actuals > 0, Actuals), 0.25) AS "1st Quartile"

 

MRWaughsome_0-1654021175008.png

Any help on how to get this expression to work would be great! Thank you

 

Labels (3)
1 Reply
marcus_sommer

Fractile() is an aggregation-function like sum() or count() and therefore the load needs an appropriate group by statement - means including all not aggregated fields.

- Marcus