Need some help with the fractile function in Qlik sense. I am trying to explore this function to implement the decile functionality that I am looking for. I have customer with Product Quantity. I want to create 10 equal distributions based on this Product quantity.
I say "Fractile(TOTAL Quantity, 0.10)". It gives me back 0.
You would need to create a synthetic table with dimension Customer and your Quantity expression and then apply the fractile function on top of it, assuming Sum(FIELD) as your Quantity expression and Customer field as your grouping entity: