Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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