Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

1 Reply
mov
Esteemed Contributor III

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

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 %>,

     <expression in abs values>

)

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

Regards,

Michael

Community Browser