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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table relative percentage

Here in this pivot table for the field volume i have written the expression

=if(Dimensionality()=0,

  Sum(Aggr(sum(Query3.Volume),Query3.Water_System,Query2.REGION,MonthName)),

   if(Dimensionality()=1,

     Sum(Aggr(sum(Query3.Volume),Query3.Water_System,MonthName))

 

  ))

Labels (1)
0 Replies