topic Re: RowToatl is different from actual total in QlikView

RowToatl is different from actual total

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 31 Aug 2018 05:26:45 GMT

Hi Pooja,

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

Regards,

Anupam

sagarjagga — Fri, 31 Aug 2018 10:12:20 GMT

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

BalaBhaskar_Qlik — Fri, 31 Aug 2018 10:33:23 GMT

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.