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
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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: 
danielact
Partner - Creator III
Partner - Creator III
‎2012-05-03 11:48 AM

Aggr in Pivot Table

I have a Pivot Table, and I'm using aggr with a rank function as a dimension. Here's the dimension:

aggr(rank(aggr(sum(Value),Field1,Field2,Field3,Field4),4,1),Field1,Field2,Field3,Field4)

I'm also using Fields 1, 2, and 3 as Dimensions, and I really want to aggregate on Field 4, but get a seperate ranking for each of the other dimensions. This is working ok so far.

If I want to collapse a dimension in the pivot table, it messes everything up. I assume it's because I'm aggregating and ranking by each of the dimensions. Is there a way to be able to collapse a dimension, and keep an accurate ranking within the dimensions I have open?

515 Views
0 Likes
0 Replies