topic Re: Pivot count of measure in App Development

Pivot count of measure

RighettiAndrea — Wed, 24 Nov 2021 08:15:18 GMT

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 — Wed, 24 Nov 2021 08:57:59 GMT

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

RighettiAndrea — Wed, 24 Nov 2021 10:28:43 GMT

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!