Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
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
Partner

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.