Reproducible Random number using Rand()

Chahine — Wed, 02 Dec 2020 07:31:16 GMT

Hi Everyone,

How can I generate a reproducible set of Random Numbers for rgb color code I am using

argb(200,rand()*225,rand()*225,rand()*225)

but it gives me every time different set of colors, is there another function ?

Thank you

Re: Reproducible Random number using Rand()

edwin — Thu, 03 Dec 2020 00:32:56 GMT

everytime you reload your script, you will get a different random number (hence the name). i use rand all the time and its hard to test esp if you need to reload multiple times. what i do is rt after the table with the rand() number fields, i save it to a QVD and next time just load the QVD and comment out the table itself.

obviously, you need to change your script after the first run. if manually changing the script is not acceptable, then you can automate it by first checking if the QVD exists, if so, load it else run the code that has the rand() and then save to QVD.

topic Re: Reproducible Random number using Rand() in QlikView

Reproducible Random number using Rand()

Re: Reproducible Random number using Rand()