topic Re: Qlik Sense: Possible to set limit in table without measures? in App Development

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

wuming79 — Thu, 25 Oct 2018 05:56:01 GMT

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?>

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

micheledenardi — Thu, 25 Oct 2018 06:19:44 GMT

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.