Qlik Sense: Possible to set limit in table without measures?

[wuming79]

Hi,

I have 5 columns of data with more than 20 rows of records. I added the fields into a table one by one and I wanted to limit the number of rows to 10. When I look into the data->columns-> the "Limitation" field is greyed out.

Is it possible to set limit without a measurement?>

[micheledenardi]

Which rule do you want to apply to "filter" these 10 record ? only the firsts 10 ? Only the lasts 10 ? Another custom rule ?

You cannot use "Limitation" because this parameter is based on the first measure.

I suggest to you to create a fake measure like below and then set 1=0 on "Conditional Show" so the "limitation" option will be available to be used.