topic Re: Pivot table % Total in Visualization and Usability

Pivot table % Total

Ah84 — Sun, 10 Apr 2022 08:08:04 GMT

maybe a simple solution but I’m relatively new to Qlik. I’m trying to replicate excel pivot table functionality, specifically the % of grand total, but the aggregations options are not present for this. Is there a expression I can use? I have selected the ‘show totals’ option, so now I want the same measure field but with each row as % of grand total.

thanks in advance

Re: Pivot table % Total

anat — Sun, 10 Apr 2022 08:57:46 GMT

Can you try like,

Sum(sales) /sum(total sales)

Or try using dimentionality

Re: Pivot table % Total

Ah84 — Sun, 10 Apr 2022 13:44:00 GMT

Thank you Anat, didn’t know the total function. All sorted.

Re: Pivot table % Total

anat — Mon, 11 Apr 2022 03:55:04 GMT

can you please mark this one as accepted solution, it will be useful for others also.