topic Re: Populating percentage in Qliksense Pivot in App Development

Populating percentage in Qliksense Pivot

karandeep — Fri, 02 May 2025 14:42:59 GMT

Hi there, I am trying to populate the %age in Qliksense Pivot similar to as populated in Excel summary below.

I have used a formula that gives the **bleep** figures rangeSum(before(count(Item),0,ColumnNo())) however not able to populate the %age, Can you please help. Thank you!

Re: Populating percentage in Qliksense Pivot

Oleg_Troyansky — Fri, 02 May 2025 15:25:29 GMT

Hi there,

For the percentage, divide your cumulative sum by the total by Department:

rangeSum(before(count(Item),0,ColumnNo())) / count( total <Department> Item)

I think this should work.

Cheers,

Re: Populating percentage in Qliksense Pivot

karandeep — Fri, 02 May 2025 17:01:44 GMT

Thank you so much, This worked! 🙂

Re: Populating percentage in Qliksense Pivot

karandeep — Mon, 27 Apr 2026 17:35:32 GMT

When a day has no value, the pivot table currently displays a hyphen or remains blank. I need an updated expression so that if, for example, Day 5 has no value, it should automatically use the same percentage shown for Day 4 instead of leaving the cell blank. Could you please help? Thank you.

Re: Populating percentage in Qliksense Pivot

karandeep — Mon, 27 Apr 2026 17:57:10 GMT

and if the first cell is blank against the department then automatically start with 0.0%, thank you.