Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mfarslnn
Contributor
Contributor

How To Pass Stored Procedure Parameters From Dashboard

Hi guys.

Currently i am trying to pass sp parameters from dashboard. I've created 4 variables which will be using in sp. Just like this;

Let vFrmnr ='600_01';

Let vFrmnr2 = '600';

Let vStartdate = '20150101';

Let vEnddate = '20150501';

LOAD *;

SQL EXECUTE LS_XXXX '$(vFrmnr)','$(vFrmnr2)','$(vStartdate)','$(vEnddate)';

Now i am trying to change those variables' values from dashboard. I've tried the well-known qs-variable extension. But i couldn't handle it.

Can someone please send me a sample .qvd for this purpose?

Thank you.

0 Replies