Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vishalmanu
New Contributor III

I hava a table with 1000 records, and the table has to show the number of record entered by customer in the input box.How to achiueve this?

I Have a Table with 1000 Records. I have provided an input box to the user. If the user enter 100 in the input box then the table has to reflect the first 100 records, if he enters 200 then first 200 records has to be reflected. Please let me know how to achieve this.

3 Replies

Re: I hava a table with 1000 records, and the table has to show the number of record entered by customer in the input box.How to achiueve this?

You need to use a straight-table or a pivot for it and not a tablebox to be able to set conditions on it, for example within an expression:

if(rowno() <= $(YourVariable), only(AnyDimension))

- Marcus

mwoolf
Honored Contributor II

Re: I hava a table with 1000 records, and the table has to show the number of record entered by customer in the input box.How to achiueve this?

If you are talking about a Straight Table, you can use Dimension Limits.

pic1.png

RonaldDoes
Contributor III

Re: I hava a table with 1000 records, and the table has to show the number of record entered by customer in the input box.How to achiueve this?

Hi Vishnu,

Please find attached an example of an input box setting a variable and a straight table showing the variable number of rows.

Naamloos.png

Hope this helps you.

With kind regards,

Ronald

Community Browser