Discussion Board for collaboration on QlikView Scripting.
i'd like to know if it's possible to pass a variable from an inputbox in a WHERE from SQL connection.
Input('Valeur dentrée', 'Zone de saisie') as v,
Recno() as r
ODBC CONNECT TO ADX_ADXV140 (XUserI ........................);
SQL SELECT *
v140.AUTO.XCUMARTCLI INNER JOIN v140.AUTO.BPCUSTOMER ON v140.AUTO.XCUMARTCLI.BPCINV_0 = v140.AUTO.BPCUSTOMER.BPCNUM_0 WHERE ((v140.AUTO.BPCUSTOMER.REP_0)= ' here the Variable v ' AND XYEAR_0 > 2008)";
Thanks for your answers.
Go to Solution.
You can force the user to enter a value and then process it in the SQL statement:
LET vWhere = Input('Condition', 'Warning'); LOAD *;SQL SELECT *FROM TableWHERE Condition = $(vWhere);
Take into account that you will have to pass a value for this variable while reloading unattended.
Hope that helps.
Thanks a lot !!!!
thats work fine
You can go for Macro. Set a trigger for variable onchange event. In its macro function force ActiveDocument.Reload.
But macros have issues with server, hence if your app goes to server then this method is not prefered one.