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]

On your Pivot Table presentation tick Show Partial Sums for the appropriate Dimension.

[Anonymous]

Also on the Presentation tab you'll find the Suppress Zero-Values and the Suppress Missing tick boxes.

[Anonymous]

for your total in red (below) use the Suggestion of Bill

for the toal on right handside define Expression sum(quantitiy*price), that gives you the total sum per product

[Anonymous]

See the attachment.

Under presentation tab - select dimension(Top left) - Show partial sum

[himanshi]

hiii,

  you have options for both in presentation tab of chart properties. their is show partial sum option for totals you can apply it for the dimension according to which you want total  and suppress zero values option for hiding null values.

Regards,

Himanshi Dubey

[raadwiptec]

partial sums are good.. but on the right hand side ..how can I have the same total quantity and total price on the right hand side.

[raadwiptec]

when I say total quantity on the right handside.. it should be something this

for example keeping months in pivot table. for jan it is 12

                                                                           feb - 15

so I need to add all the  columns for sam and then make the total of quantity he purchased for the year.

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

[himanshi]

hiii,

  you can use above expression like

sum(price) for total price and sum(quantity) for total q.

[himanshi]

or you can try sum(column(3)) for total Q and sum(column(4)) for total price.