Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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!