Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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