totals

[raadwiptec]

hi All,

The below is pivot table I am using to build in qlikview

customer name	product	quantity	price	Total Q	Total price
sam	aa	12	500
kim	ss	10	235
abc	ss	1000	4445
def	dd	200	1500
Total

quantity and price are expressions.

basically I need the suggestion for one in Red.

on the right handside total Qua and total Price

on the below again -  Total

any suggestions. I do not find any option to show up the totals

My second issue is to suppress the null and missing for expression values under pivot table.

[Anonymous]

In pivot table, you can use slicing/Dicing features,

CustomerName          Product                 Quantity(JAN)       Quantity(Feb)so on    Price     Total Q       Total Price

sam                                aa                            12                           15

kim                                   ss

and so on             

I hope this is what you are looking for.

Just take Month as a Dimension and slice it you would get Month in the Horizontal way;

Total Q:  sum(Quantitiy) as Total Q

Total Price:        sum(Quantitiy)*sum(Price) as Total Price

Hope this will help

[raadwiptec]

Hi balraj,

if I do as u mentioned I get the sum for each month ..which is not correct. I need the total.

[raadwiptec]

for example for the above my total should be 27..

[Anonymous]

Do you have Month as a DIM?

It shud give you 27 only..

[Anonymous]

Or you can try:

=sum( Total CustomerName Quantity)

will sum by customer and wud give 27

[sasikanth]

Please see the attachment

[Anonymous]

=sum( <Total CustomerName> Quantity)  //check the syntax

[raadwiptec]

no the solution is just select the month and use partial sums.. it is working thanks all