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