topic Re: Fractile in QlikView

Fractile

andrea90casa — Tue, 21 Nov 2017 13:55:30 GMT

Hi at all,

I have this situation

Products Quantity Unit Price Total Amount

Product A 100 10 1000

Product B 50 5 250

Product A 50 10 500

Product C 10 4 40

Then i calculated the total amount for each product with this formula

aggr( sum(Unit_Price * Quantity),Product)

Then i would like to calc the fractile 25% using this formula

fractile(TOTAL aggr( sum(Unit_Price * Quantity),Product),0.25)

Now i would like to select a product and still obtain the correct value of fractile and so i tried with this formula

fractile(TOTAL {<Product>} aggr( sum(Unit_Price * Quantity),Product),0.25)

But if i select a product the value of fractile change and it shows me the total amount.

How can i solve it?

Andrea

Re: Fractile

Anil_Babu_Samineni — Tue, 21 Nov 2017 14:09:14 GMT

What if your removed TOTAL in your last expression

Re: Fractile

YoussefBelloum — Tue, 21 Nov 2017 14:15:15 GMT

Hi, try this:

fractile(TOTAL {<Products>} aggr( sum({<Products= >}[Unit Price] * Quantity),Products),0.25)

Re: Fractile

sunny_talwar — Tue, 21 Nov 2017 14:24:39 GMT

youssefbelloum‌ is right, in order to ignore selection in Product field, you need to ignore the selection in Products in not only your outer aggregation, but also the inner Sum()

Re: Fractile

andrea90casa — Tue, 21 Nov 2017 14:33:33 GMT

Hi Youssef,

Thanks for your help. I have tried with {<Product>} inside the sum() but it didn't give to me the correct value but then i found my error....i was not considering a second field and so the value of fractile was wrong.

Thanks againg

Andrea

Re: Fractile

YoussefBelloum — Tue, 21 Nov 2017 14:35:46 GMT

you're welcome !

don't forget to close the Thread