topic Urgent Reply(Scripting) in QlikView

Urgent Reply(Scripting)

Fri, 31 Jul 2009 12:00:54 GMT

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

amars — Fri, 31 Jul 2009 12:18:06 GMT

Hi Sikandar,

See a link below to accept a value in a variable

(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

Fri, 31 Jul 2009 12:43:51 GMT

Hi,

Encolsed is the file.

regards

Amit