Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
mick1234
Contributor II
Contributor II

Call SQl procedure with input value

Please help me, using Qlik Desktop 2018 Patch 2, 12.44.3 version I create SQL procedure

SQL EXEC [Procedure] @WORKPLACE_ID=[$(vPara1)], @CHANGE_TS_VALUE1=[$(vPara2)], @CHANGE_TS_VALUE2=[$(vPara3)];

And call it Using Inside Data load editor section

LET vPara1 ='34534534'; 
LET vPara2 = '2018-12-01 00:00'; 
LET vPara3 = '2018-12-02 00:00';

My question is how it's possible to input value from App side(screen below): using the filter, custom object, input box whatever and click on reload button to generate the result from the procedure by clicking load dateprocedure.png

0 Replies