Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalmanu
Partner - Creator
Partner - Creator

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
marcus_sommer

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

m_woolf
Master II
Master II

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

pic1.png

RonaldDoes
Partner - Creator III
Partner - Creator III

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