topic horizontal total in Pivot Table Qikview in QlikView

horizontal total in Pivot Table Qikview

kiranpatil123 — Tue, 18 Jun 2019 07:57:49 GMT

Hi All ,

Unit	Count of Product	Count of Article	Count of Material	Total
A	10	1	100	111
B	20	2	200	222
c	30	3	300	333
D	14	4	400	418
E	18	5	500	523
Total	92	15	1500	1607

I have above Table . I need horizontal Total ( Colored in green ) .

Help me with Expression using rangesum or Secondary Dimesnionality or any other way .

Note that Count of Product , Article ,Material are 3 different expression

Re: horizontal total in Pivot Table Qikview

sunilpaul — Tue, 18 Jun 2019 10:50:37 GMT

Hi,

use the following expression as additional Measure :
= Sum([Count of Product]) + Sum([Count of Article]) + Sum([Count of Material])
* replace Count of Product , Article ,Material with their expression in above expression.

Regards

Re: horizontal total in Pivot Table Qikview

Frank_Hartmann — Tue, 18 Jun 2019 10:57:46 GMT

Add a fourth expression:

Column(1)+Column(2)+Column(3)

Re: horizontal total in Pivot Table Qikview

kiranpatil123 — Tue, 18 Jun 2019 11:15:36 GMT

Thanks SunilPaul

That's Simple

I think i over thought too much 🙂

Re: horizontal total in Pivot Table Qikview

sunilpaul — Tue, 18 Jun 2019 11:49:29 GMT

Happens 🙂