topic Re: Creating random numbers on button click in QlikView

Creating random numbers on button click

dineshmdane — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Want to create random numbers on clicking a button.

Example :

clicking a button produce a number '3' and clicking the same button again produce another number '7' and so on.within the limit of 20.

Kindly awaiting for your response

Regards,

Dinesh M

Re: Creating random numbers on button click

swuehl — Thu, 02 Mar 2017 14:04:19 GMT

Maybe create an External - Set Variable action in the button properties and set a variable value to

=Ceil(RAND()*20)

Re: Creating random numbers on button click

marcus_sommer — Thu, 02 Mar 2017 14:05:09 GMT

Maybe this is helpful: Re: Generate 6 different random numbers

- Marcus

Re: Creating random numbers on button click

sunny_talwar — Thu, 02 Mar 2017 14:05:51 GMT

Do you know why it wouldn't work for me in the attached file. Seems like the value for Rand() just doesn't want to change

Re: Creating random numbers on button click

adamdavi3s — Thu, 02 Mar 2017 14:40:54 GMT

It's weird but maybe it only recalculates when something changes?

I changed it to rand*now() and clicking the button does then work

Re: Creating random numbers on button click

swuehl — Thu, 02 Mar 2017 14:41:24 GMT

Seems like some kind of caching is kicking in.

We may need to force Qlik to reevaluate the expression:

=Ceil(RAND()*100) +0*Now(1)

(Sometimes it takes more than 1 click to change)

Re: Creating random numbers on button click

sasiparupudi1 — Thu, 02 Mar 2017 14:51:09 GMT

May be use a piece of macro

sub Random

set vRand = ActiveDocument.GetVariable("vRand")

x= rnd*20

vRand.setContent x,True

End sub

Re: Creating random numbers on button click

dineshmdane — Fri, 03 Mar 2017 05:27:35 GMT

Ya Sunny on button click it will not change.It will change only on reload.

Thank you.

Re: Creating random numbers on button click

dineshmdane — Fri, 03 Mar 2017 05:32:15 GMT

Thanks you Stefan it is working as you said it takes more that one click sometimes .

Any other method to change the value on one click.

Re: Creating random numbers on button click

dineshmdane — Fri, 03 Mar 2017 05:46:27 GMT

Thank you Sasidhar. It is working.

Re: Creating random numbers on button click

sasiparupudi1 — Fri, 03 Mar 2017 07:59:25 GMT

Great, if you are happy with the solutions give by us, please do not forget to close the thread by marking a correct and any helpful answers