topic Re: Dynamic Variable to be passed in script in Qlik Automate

Dynamic Variable to be passed in script

AT_7 — Tue, 14 May 2024 08:38:15 GMT

Hi,

I have a requirement in which my front end user will pass a input variable and expression should get updated ,My expression is define in script not as chart function.

Set vTest= 50

LOAD *, If(Qty > $(vTest), 'Store1', If(Qty > another_threshold, 'Store2', If(Qty > another_threshold_2, 'Store3', 'Store4') )) as Logic FROM table;

now in front i have an input variable linked with vTest and in a table Logic field is used.

When an end user pass different value in vTest than Logic dimension i snot getting updated even if i refresh app from fornt end .

Kindly help

Re: Dynamic Variable to be passed in script

HirisH_V7 — Wed, 15 May 2024 19:02:25 GMT

If you have vizlib in your infra, then you can create a write back table. Then by clicking on a reload button, will fetch that value and load the results.

Other stable work around may be, you can create that expression in UI and pass the variable via input box.

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/DashboardBundle/variable-input.htm#:~:text=Input%20box%20provides%20a%20simple,step%20to%20use%20with%20Step.

Re: Dynamic Variable to be passed in script

AT_7 — Thu, 16 May 2024 08:58:13 GMT

Thank you for replying . But unfortunately it didnt work, i tried to bring Vaiable input control and assigned that variable to it. When i changed the value and reload it nothing got updated in logic 😞 i mean it didnt write it back to table and updated expression .