Using a Slider to define the number of records to Reload

[#1]

I have a question with regards to loading records.

I have an app that loads a large volume of records, I want it to load a random sample between 1 and X and I want to allow the user to select the X value by using the slider. So that when the user selects Reload the data, the app will take into account the value selected on  the slider (variable) for the reload count.

Could someone point me in the right direction with this please?

Thanks in advance

Robin

[Gysbert_Wassenaar · Accepted solution]

Use the slider to set a variable (i.e. vRecords) to the number of records you want to load. Then change the load to use the variable:

FIRST $(vRecords)

LOAD ...etc....

Note, this will only work if users are using Qlikview Desktop and open the document directly. Documents opened on the server can't be reloaded by the user.

[#3]

My bad ,, apologies, it works perfectly, I had not set the initial variable value.

Thanks for the assist,

Robin