topic Re: variable in access password load in QlikView

variable in access password load

rafael5958 — Thu, 27 Aug 2020 14:33:05 GMT

Is there a way to put a variable in access section?

Something like:

Section Access; replace LOAD * INLINE [ ACCESS, USERID, PASSWORD, NTNAME ADMIN, $(vUser), $(vPassword),* ]; Section Application;

So I could run from cmd and set user and password?

Like:

"c:\Program Files\QlikView\Qv.exe" /r /vUser="User1" /vPassword="1234" "sss.qvw"

Re: variable in access password load

marcus_sommer — Thu, 27 Aug 2020 15:42:58 GMT

What is the aim of your intention? Why not just using NTNAME for the authentication?

I'm not sure how the order is in which the parameters are applied - means comes the reload first and then the variable-value is set or is it reverse and also if you could repeat the /v parameter for multiple variables or if it needs a different syntax? But this could you simply test - maybe within any dummy-application without section access.

Beside this your syntax/logic isn't quite right because you missed a v and I'm not sure if the variable-values need a quotes-wrapping or not - therefore to set the variable vUser the parameter should rather look like: /vvUser=YourValue.

Further you tries to apply a partial load with replace - if this will really work with section access? If yes, you need also to change the parameter /r to /rp.

- Marcus

Re: variable in access password load

rafael5958 — Thu, 27 Aug 2020 21:25:08 GMT

D:\Qlikview\>"C:\Program Files\QlikView\Qv.exe" /r /vUserL=user4 /vPassL=123456 test.qvw

replace LOAD * INLINE [ ACCESS, USERID, PASSWORD, NTNAME ADMIN, $(UserL), $(PassL),* ]; Section Application;

Worked for my needs.