Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
Any help on how to get this expression to work would be great! Thank you
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