topic Re: Random Number in QlikView

Random Number

ashishpalkar — Thu, 14 Sep 2017 21:38:52 GMT

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 — Thu, 14 Sep 2017 21:42:48 GMT

Something like

ROUND(RAND()*60) -30

ashishpalkar — Fri, 15 Sep 2017 02:57:13 GMT

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

swuehl — Fri, 15 Sep 2017 06:29:10 GMT

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

ashishpalkar — Mon, 18 Sep 2017 17:00:06 GMT

How we can do this in Qlik sense ?

swuehl — Mon, 18 Sep 2017 17:14:06 GMT

In your script, use e.g.

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

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