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 .
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.
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 .
