Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Encolsed is the file.
regards
Amit