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

Cumulate having multiple Dimension in Pivot

Hello

I have a pivot table with multiple dimension, and I am trying to cumulate the values based on the logistic Type (header) as shown below

   

LABLeadTimeLogisticOrderTypeInvoice Date05/03/2017
MTCSAAV4411%
MTCSACD-
MTCSAAP-
MTCSBAV242880%
MTCSBRR1
MTCSBFF4
MTCSBCF-
MTCSBCD295
MTCSBAP6
MTCSCAV735100%
MTCSCRR2
MTCSCFF-
MTCSCCF-
MTCSCCD736
MTCSCAP63

for eg, AV in Logistic type repeats for A, B, C I want to add 4 to 24 for B and 7 to 28

AV has to cumulate to 100% in C

Please help I have attached a file as well

1 Reply
ahaahaaha
Partner - Master
Partner - Master

Hi,

May be as variant in attached file. I especially did not delete the intermediate expressions (made them hidden in the settings), so that the computational logic was understandable.

Regards,

Andrey