Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table - Creating a Restriction in Display of a Dimension

Hi everyone, I have a pivot table which has:

  • time spanning across the top
  • a list of systems going down
  • and an expression sum(impact) which populates the cells.

Is there a way I could possibly limit the number of systems going down to the top 10? I can't seem to find a way in the pivot table. The systems are currently ordered by the descending total of the expression: sum(impact).

Would set analysis in some way solve this problem as when I create the table it shows all the systems available within the selection I have made. Or should I make a calculated dimension?

If you could help it would be much appreciated. Thanks.

5 Replies
Not applicable


Try something like this in u r dimensions

=If(Aggr(Rank(Sum(impact),[systems ])<11,[systems ],'All Other ')

and keep the other same as it is

It should work


Not applicable

Hi Talha,

Thanks for your response. I've tried that expression but I get the 'error in expression' comment. I think there may be a problem with the brackets but i can't see what it is!

Not applicable

Can you send me the exact Field names or else one application with the mockup data in that.


Not applicable


Date: MonthYear

The column from top to bottom is: SystemName

Expression: sum(Impact)


Not applicable

Try this out

=If(Aggr(Rank(Sum(Impact)),SystemName)<11,SystemName,'All Other ')

This should work