TOTAL expression not counting correctly

paulinhok14 — Tue, 05 Mar 2024 13:36:50 GMT

Hello dears!

I have an app in which I want to create a pie chart with relative classification, in %, for a specific field.

My field called "_Essentiality" has binary classification (0/1) and I want to count my Key field (%CompoundKey) for each of these classifications, having percentage for each class, example:

_Essentiality	Relative Count
0	97,3%
1	2,7%

But the problem is, when I try to use TOTAL expression in order to have my relative share, my TOTAL count doesn't match with the sum of Keys in each classification (see attached image):

As you can see, my count considering Dimension totals 49055 and my total count shows 49030, so when I try to create the A / B in order to have 0-100% sum, my "0" classification become, solely, more than 100%.

I've also tried to use ALL expression, without success.

Any ideas?

Re: TOTAL expression not counting correctly

WaltShpuntoff — Wed, 06 Mar 2024 23:23:48 GMT

I am assuming that your field %CompoundKey is a record key.

Whenever you are counting record keys - you always have to use Distinct.

Give that a try and post results.

hth

-ws

Re: TOTAL expression not counting correctly

marcus_sommer — Thu, 07 Mar 2024 08:15:47 GMT

Solved: Re: TOTAL expression not counting correctly - Qlik Community - 2427177

topic TOTAL expression not counting correctly in App Development

TOTAL expression not counting correctly

Re: TOTAL expression not counting correctly

Re: TOTAL expression not counting correctly