RowToatl is different from actual total

[Anonymous]

Hi Team,

From following table my actual total sum is 921 but in qlikview its showing only 919. Can you help me to get actual total sum ?

IF(len(SHP_ProblemCategory)>0,Replace(SHP_ProblemCategory,' ',chr(8)))	Count	CumulativeSum
Total	919
1	28	28
2	9	37
3	177	214
4	87	301
5	77	378
6	24	402
7	27	429
8	23	452
9	7	459
10	29	488
11	5	493
12	344	837
13	43	880
14	13	893
15	28	921

regards,

Pooja

[dx_anupam]

Hi Pooja,

Can you please provide a sample data / app so that we can check what exact issue is.

Regards,

Anupam

[sagarjagga]

Hi Pooja,

it could be possible that you have duplicate measure values among 2/3 dimensions and to find out count you may be using distinct function

[balabhaskarqlik]

In, Chart properties - Expression tab - Add expression.  Then you can modify the Total mode as below specified and try.

By the selected option, Totals calculated correctly.