Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
surendraj
Specialist
Specialist

caliculate sum formula in pivot table

Hi Guys,

I have a requirement where my values are in pivot table 

 

                      date               April 1                           May  1

                     Type   count     value  total            count     value    total      whole total

                      Type 1   3            5          15(3*5)       3              4           12           15+12=27

Product      Type 2   4          6           24                4             7             28           24+28=52

Please suggest me how to caliculate that whole total value in my pivot table..

 

--Surendra

 

Labels (1)
3 Replies
MindaugasBacius
Partner
Partner

This might help:

Screenshot_1.jpg

surendraj
Specialist
Specialist
Author

No it is giving full total..by row wise.

and we have also several expressions in expressions tab.

That whole total value should came(pick) from each date wise.

julien_saintmaxent
Luminary Alumni
Luminary Alumni

Hi,

I think you must calculate each values with set analysis per month and on the last the cumul with the function column.

Sum({$<Month={'April'}>value)

Sum({$<Month={'April'}>Volume)

Column(1)*column(2)

etc

you can automatise the value of the month also.

Bye