Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to pass dynamic parameters to an SAP query

Hi All!

How can I fill a select option of an SAP query without using a variant?
I'd Like to fill it dynamically from my script. I can't find this option when using the SAP Query Connector.

Please advice. What I'm doing wrong?

./. Xan

3 Replies
tabletuner
Contributor III

How to pass dynamic parameters to an SAP query

i use qv variables to communicate dynamic queries e.g.

sql select *

FROM BSEG

WHERE GJAHR='$(vVariable)''

Not applicable

How to pass dynamic parameters to an SAP query

Hi Tjeerd,

With tables everything is fine.... but I want to pass such a variable to an SAP query select option. There is no WHERE part....

Xun

Not applicable

How to pass dynamic parameters to an SAP query

Hi xanwu,

dynamic parameters are supported by Xtract QV, the alternative SAP Connector by Theobald Software:http://www.theobald-software.com/en/download/xtractqv.htm