Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

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