topic Variable losing changes after Data Reload / Qlik View in QlikView

Variable losing changes after Data Reload / Qlik View

Christos500 — Tue, 24 Jan 2023 07:27:08 GMT

Hello, i have this particular problem. I have a measure saved in a variable and i want to make a change and add something to it. When i m done i save it and exit the app. When i open the app i see the change. The problem is the other day when the data reload occurs. The change that i 've made last day isn't there. I have tried many ways to fix this, such as to remove variable and create it again, set the variable in the script with null() and then try to create it again in the UI and more.

The thing is that this variable is a part of another variable that consists many other variables. To tell you more, the variable i try to change is a discount amount ( disc1)that is part of a bigger group of discounts (disc = disc1 + disc2 + ........). So every disc is in a variable and the total disc (disc) is in a variable. I tried to delete disc and the disc1 and try to reload and see but everytime i reload (even if i have deleted the variable/s first ) when i make the change i get the old wrong values.

plz help!!

Re: Variable losing changes after Data Reload / Qlik View

Mark_Little — Tue, 24 Jan 2023 08:13:26 GMT

Hi,

It sounds like it is getting set in the Script, i would work through and makes sure it is getting set as you require. Look for any include statements as it might be a an external script

Re: Variable losing changes after Data Reload / Qlik View

Christos500 — Tue, 24 Jan 2023 10:28:40 GMT

thank you !! actually it has a script section with a for loop that reads all the variables from an external excel file. So in this case, changes in the UI for the particular variable was only temporarily, as at the reload time the script overwrites the ui values for the variables.