Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
RighettiAndrea
Contributor III
Contributor III

Pivot count of measure

Hi everyone,

RighettiAndrea_0-1637741594486.png

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!

1 Solution

Accepted Solutions
Or
MVP
MVP

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

 

 

View solution in original post

2 Replies
Or
MVP
MVP

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
Contributor III
Contributor III
Author

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!