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.
Can you provide QVF file so that I can review please.
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?
You can limit a dimension when you have a measure (on which the limitation will be calculated)
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.