How to write random number in Qlik like this.
I am using excel formula like below.
Thanks Stefan , but this value is changing in every click. I want something where value changes only after opening / refreshing the App.
Then either calculate the number in your script or use a document OnOpen trigger action to set a variable once when opening.
How we can do this in Qlik sense ?
In your script, use e.g.
Let vNumber = ROUND(RAND()*60)-30;
The variable vNumber is updated on each reload of the script.
Retrieving data ...