Limitation to records

[Kmt2000]

I want to take user input for limiting the number of records.for eg. Suppose if user input value is 5 then it will show only 5records,if user value is 10 then it will show 10records only.how i will make this happen??

[AshutoshBhumkar]

Hi,

maybe something like below

1. Take input value from the user in excel.

2. Take that value in a variable using peek or any other suitable function.

3. Use that variable in where condition of loading table. 

[Digvijay_Singh]

May be you try using variable in the dimension limit property of a chart, and update variable value in the text box or in the variable input object in the dashboard bundle.

[vikasmahajan]

Hi Kmt2000,

Actually you can load full data and apply ODAG  functionality see https://www.youtube.com/watch?v=Ft3I00-g4H4

Thanks

Vikas 

[Kmt2000]

I am new to qlik,i know how to create variable,but please tell me what will be the expression of that variable which will accept the user input,that will be big help for me.thank you

[Digvijay_Singh]

May be something like in the attached app, not sure if thats the exact need, just an idea

[Kmt2000 · Accepted solution]

Its working but what is the expression for vCount variable?

[Digvijay_Singh]

There is no expression I used, just used the variable in the dimension limit property, not sure if you need it this way..

[Kmt2000]

Thank you so much,now its working as i wanted. 

[Kmt2000]

Thank you everyone for your replys.