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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-01-31 04:00 AM

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)
Labels
Pivot table.xls
589 Views
0 Likes
0 Replies