Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to limit the number of rows in table based on button click

hi

I have a table with several rows and columns(a, b, c) and I have 3 buttons.The c column will be set to ascending order. When I click first button, I should get first 3 rows. when I click second button, I should get first 5 rows and so on. How can I achieve this ?

Thanks,

1 Reply
sibin_jacob
Creator III
Creator III

Hi,

screen_shot.jpg

We can limit rows in a table based on first expression only.

You may use one variable. Based on button click you can set value of that variable(3 or 5).

In your table properties dimension limit tab->check on restrict values->

select shiw only -> First

Please see the attached screen shot.

Thanks

Sibin