Is it possible to call sql procedure with parameters in Qlik Sense

[Anonymous]

Hi,

I am new to Qlik sense  and I am  trying to create a  dash board application which contains one or more filter drop downs and charts. based on the values selected in the filter charts needs to be refreshed.

I need help in accessing filter selected values and passing them as parameter to sql procedure for binding the charts.

looking forward for the suggestions..

[felipedl]

Hi Amit,

That isn't possible because the functions that return selections are for charts (UI) and not for the script part of Qlik.

Example: GetCurrentField ‒ QlikView

Therefore, you wouldn't be able to catch what the user selects and then use it for the procedure with that kind of logic.

You would have to specify in the load statement the fields your passing to the stored procedure.

Felipe.

[Anonymous]

Thanks for your reply Felipe.