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

Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Urgent Reply(Scripting)

Hi

I m in deep trouble and I need the solution as soon as possible.

first 10 load "CUST_ID" as ID, sum("AMOUNT_SOLD") as top
resident Sales
group by "CUST_ID"
order by "CUST_ID" desc;

In the above ,you can see that after the key word of First i have hardcode the value 10 which will gve me the

first 10 records of customer.what i need is when i click on the reload button user must enter the record

value which he has to seen.i donot want the hardcode value.i want the user to enter 10 after when he hits the

reload button.how can i achieve this?Please reply me as soon as possible as i badly need this solution.

Thank you so much...

Regards

Sikandar Naeem Khan

2 Replies
amars
Specialist
Specialist

Hi Sikandar,

See a link below to accept a value in a variable

http://community.qlik.com/forums/t/16998.aspx

(the link is for accepting a date but you can use it to accept a number)

I am not sure about it but try to use a function like RowNo() (in sql or any db) < $Variable accepted

See if this help

Regard's

Amar

Not applicable
Author

Hi,

Encolsed is the file.

regards

Amit