topic how to add rows? in QlikView

how to add rows?

shruthibk — Wed, 09 Dec 2015 05:56:10 GMT

Hi all,

i got requirement to find the total.where the total will be sum(product b and product C) but i have product a also ,how can i achieve this in pivot table?here the fields value a,b,c coming from different qvd's which i taken into same field.plz help me to achieve this asap.

i have to build the same chart as showing in excel,

plz find the sample data

Re: how to add rows?

Gysbert_Wassenaar — Sat, 12 Dec 2015 18:28:46 GMT

You can't add rows to a table in a pivot table. You could abuse the partial sums to use the total line to show two values. Enable the Partial Sums option of the Product dimension and use an expression like:

If(Dimensionality()=0, sum({<Product={'b','c'}>}Value) & chr(10) & num(sum({<Product={'a'}>}Value)/sum({<Product={'b','c'}>}Value),'0.0%'),sum(Value))