Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
How to write random number in Qlik like this.
I am using excel formula like below.
Data!B367+RANDBETWEEN(-30,30)
Thanks
In your script, use e.g.
Let vNumber = ROUND(RAND()*60)-30;
The variable vNumber is updated on each reload of the script.
Something like
ROUND(RAND()*60) -30
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.