combining in a pivot relative and absolute values for the same expression

Mon, 11 Nov 2013 14:13:01 GMT

Dear all,

I think I have between my hands a challenging visualisation need!

I have a pivot which is basically summarising performance of shipped line: on time, delayed by 1 day, delayed by 2 or more days.

The tricky part is that the values within the pivot table should be expressed in percentages, meanwhile the (sub)totals in absolute values

so if I have for example 3 different customers purchasing two different products:

- the total of order lines shipped for products A and B should be 1000

- the total of order lines shipped to costumers x,y,z should be 1000

- one should be able to see that for customer x ordering product B, 30% lines were shipped on time, 40% +1 day and 30% delayed.

Is this something achievable in QV? Otherwise the way to report this data (which I am trying to avoid as much as possible!) would be Excel (also due to other formatting issues)

thank you very much

regards

erik

Re: combining in a pivot relative and absolute values for the same expression

Anonymous — Mon, 11 Nov 2013 14:41:48 GMT

Eric,

Without going into details - you can have different expressions in totals Use dimensionality() as condition, for example:

if(dimensionality()=0,

<expression for total in %>,

)

Depending on the specific of your table it could be secondarydimensionality().

Regards,

Michael

topic combining in a pivot relative and absolute values for the same expression in QlikView

combining in a pivot relative and absolute values for the same expression

Re: combining in a pivot relative and absolute values for the same expression