topic Re: Relative checkbox is not working in QlikView

Relative checkbox is not working

Anonymous — Fri, 22 Dec 2017 14:38:17 GMT

Hi,

I am trying to add two expression in one pivot table, I have displayed the type, count and count as relative:

Type Count Count as relative

Type1 208 9.85%

Type2 1470 69.60%

Type3 71 3.36%

Type4 170 8.05%

Type5 191 9.04%

Type6 2 0.09%

Total 1732 100%

That is the values of the tables, but if I divided 208/1732 = 12.01%

1470/1732*100= 84.88%

As you can see the numbers are not matching, how can I get the percentage working?

sunny_talwar — Fri, 22 Dec 2017 14:41:57 GMT

If I manually sum all the values for Type, I get 2112... so I think the calculation is 208/2112.... how are you getting a total of 1732?

Anonymous — Fri, 22 Dec 2017 15:05:10 GMT

Using the Total Mode "Expression Total" but if I click on SUM, I got the correct data and the percentage is matching now.

sunny_talwar — Fri, 22 Dec 2017 15:08:37 GMT

So you managed to get 12.01%? Really?

Anonymous — Fri, 22 Dec 2017 15:21:23 GMT

No, I have as total 1732, so I guessed that the percentage was wrong, but now I identified that the problem was with the SUM