Random Number

[ashishpalkar]

Hi There

How to write random number in Qlik like this.

I am using excel formula like below.

Data!B367+RANDBETWEEN(-30,30)

Thanks

[swuehl]

Something like

ROUND(RAND()*60) -30

[ashishpalkar]

Thanks Stefan , but this value is changing in every click. I want something where value changes only after opening / refreshing the App.

[swuehl]

Then either calculate the number in your script or use a document OnOpen trigger action to set a variable once when opening.

[ashishpalkar]

How we can do this in Qlik sense ?

[swuehl · Accepted solution]

In your script, use e.g.

Let vNumber = ROUND(RAND()*60)-30;

The variable vNumber is updated on each reload of the script.