Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
On your Pivot Table presentation tick Show Partial Sums for the appropriate Dimension.
Also on the Presentation tab you'll find the Suppress Zero-Values and the Suppress Missing tick boxes.
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
See the attachment.
Under presentation tab - select dimension(Top left) - Show partial sum
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
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.
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 |
hiii,
you can use above expression like
sum(price) for total price and sum(quantity) for total q.
or you can try sum(column(3)) for total Q and sum(column(4)) for total price.