Pivot count of measure

[RighettiAndrea]

Hi everyone,

I have a pivot like this, the measure is correct and based on other values in the app.

I'd like to count how many "F" I need to reach the 20%, 30%, 50% and so on but I don't know how to do it.

Is it possibile? 

Thanks a lot!

[Or · Accepted solution]

Essentially, it sounds like you want to get the running total of the Mea1 field and then place that in an if() statement to catch the percentiles.

Have a look at this for additional details on accumulative sums - it's for Qlikview but mostly applies to Qlik Sense: https://community.qlik.com/t5/Qlik-Design-Blog/Accumulative-Sums/ba-p/1468010

And this: https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867

[RighettiAndrea]

Thanks a lot! I found what I was looking for and with a little bit of effort to apply what I read, I got my measure!