Passing parameter in sql part in qlik extractor

[sarath_babu]

Hi Team,

I have to pass a parameter in extractor in the sql part.

Normally in Mysql i have used the below query:

select s.* from (select @p1:=786) parm,  Agent_Response  s;

(@p1 refers to a parameter in Mysql function)

I need to apply the above parameter to retrieve the data related to 786 client.

I have used in qlik like below script bit it gave me error.

Agent_Response:
LOAD id,
`client_id`,
`date`,
duration;
SQL SELECT id,
`client_id`,
`date`,
duration
FROM (select @p1:=786 p) parm ,Agent_Response`;

Please help in achieving this