topic Re: Pivot Table not showing the correct Percentages against Totals in QlikView

Pivot Table not showing the correct Percentages against Totals

xlSb — Tue, 09 Feb 2021 17:24:25 GMT

Hi,

I'm trying to calculate the percentage for each row (Hour) by column (Day) where the column (Day)percentage should total 100%. But I'm running into an issue where the row total doesn't sum upto 100%. I feel like it has something to do with zero divide by zero. I have tried multiple methods where I have used, if(isnull()), alt(), if( not isnull()) etc

Re: Pivot Table not showing the correct Percentages against Totals

jmmolero — Wed, 05 Aug 2020 10:02:36 GMT

could you show the measure expression?

Re: Pivot Table not showing the correct Percentages against Totals

xlSb — Wed, 05 Aug 2020 12:56:58 GMT

sure - =(if(Source=1,count(DISTINCT %Customer)/count(total<Day> DISTINCT %Customer)))

Re: Pivot Table not showing the correct Percentages against Totals

jmmolero — Thu, 06 Aug 2020 05:29:18 GMT

Did you try with set analysis?:

count({<Source={1}>}DISTINCT %Customer)/count({<Source={1}>} total<Day> DISTINCT %Customer)

Re: Pivot Table not showing the correct Percentages against Totals

xlSb — Tue, 09 Feb 2021 17:24:54 GMT

Hi, yes I have also tried with Set Analysis. Below is what the output looks like.

Re: Pivot Table not showing the correct Percentages against Totals

Brett_Bleess — Tue, 18 Aug 2020 19:22:38 GMT

I would recommend reviewing the following Design Blog post regarding Rounding errors, believe that will likely explain things:

https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

Regards,
Brett