Variable input not working for an analyzer user after publishing the app but it works for me as professional.

[M_B]

Hello community,

I have recently built an app where the output was conditioned by a time-frame. I defined 2 variables in the load script and referenced them in the SQL query in the 'where ... between' clause. I placed 2 variable input boxes in the sheet and defined the value as input. I placed a reload button to allow users to initiate a data load after entering the start and end dates they required.

I published the app and tested the variable inputs and the reload button and it worked perfectly but only for me. A user with an analyzer license could type in the values but upon hitting reload the values would revert and no load would occur.

I tried adding the "create", "update" and even "publish" permissions in the QMC to the users group with different combinations of "Analytic_connection_*", "Data_connections_*", etc but nothing worked. Running an audit would show the user had C, R, U, P but nothing allowed them to update the variable and reload the data.

Does anyone have experience with this issue or any pointers?

Thanks in advance.

[Or · Accepted solution]

Alas, what you are trying to achieve is not possible...

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-User-with-Analyzer-license-cannot...

[M_B]

I searched everywhere online but did not come across this. Thank you for the link.

Any idea how else I can achieve this result?

[Or]

The "normal" approach would be to use ODAG. You could write something up using the reload API so it runs with the internal user, probably.