Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
LesJean
Contributor III
Contributor III

Dimension limitation greyed out

Hello everyone,

I'm trying to display only the top 5 values in a table, while browsing this forum it seems that the way to do it would be by using the "Limitation" functionality of Qlik but mine is greyed out, any clue as to why that might be?

Here's a screenshot of the greyed out option.

2019-04-16_14-45-30.png

 

Thank you,

LesJean

 

 

4 Replies
formosasol
Partner - Contributor III
Partner - Contributor III

Hi LesJean

Can you provide QVF file so that I can review please.

Frank

max31
Contributor III
Contributor III

I have the same problem.

There is only one columns in my table. The dimension is a master item. I use a custom sorting by expression.

I guess we can only limit a measure, right?

lorenzoconforti
Specialist II
Specialist II

You can limit a dimension when you have a measure (on which the limitation will be calculated)

max31
Contributor III
Contributor III

Yes you're right.

So I added a measure that corresponds to my sorting expression and put an expression that is always wrong in "Show column if" field.

This way I can have a limitation on my dimension and only one column.