Passing parameter in sql part in qlik extractor

sarath_babu — Thu, 18 Apr 2019 06:59:00 GMT

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

topic Passing parameter in sql part in qlik extractor in App Development