topic Re: Rand() function not working in Accesspoint on Refresh in QlikView

Rand() function not working in Accesspoint on Refresh

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

Hi All,

I have used rand function in UI. When I reload I have to get another rand value.

It works fine in my local web view. But it is not working in accesspoint, the same rand value is shown on refresh.

Kindly help me on this.

Regards,

Dinesh M

Re: Rand() function not working in Accesspoint on Refresh

Anil_Babu_Samineni — Thu, 22 Jun 2017 11:03:04 GMT

For me it's working in IE, Mozilla, Safari, Chrome, Opera? Which Browser you are using? Can you explain little more

Re: Rand() function not working in Accesspoint on Refresh

dineshmdane — Thu, 22 Jun 2017 11:51:32 GMT

Hi Anil,

I have used '=rand()' in text object.

And I tested in chrome.

Re: Rand() function not working in Accesspoint on Refresh

dineshmdane — Wed, 28 Jun 2017 08:50:49 GMT

Any inputs regarding this query. Kindly respond.

Re: Rand() function not working in Accesspoint on Refresh

Anil_Babu_Samineni — Wed, 28 Jun 2017 09:05:36 GMT

May be explain little more with images, Please? Because we need to understand the issue over image. I am not sure why this is not working for you

Re: Rand() function not working in Accesspoint on Refresh

dineshmdane — Wed, 28 Jun 2017 11:55:16 GMT

Hi Anil,

I have used rand function as below in text box :

And I have also tried using Variable vRAND = rand() as below :

In my local the values in text box got changed on reload but in accesspoint both of the above method fails on refresh the values does not changed.

Regards,

Dinesh M

Re: Rand() function not working in Accesspoint on Refresh

Anil_Babu_Samineni — Wed, 28 Jun 2017 12:49:26 GMT

I am not sure, Why this is not working for you. Wait for his response Peter Cammaert

Re: Rand() function not working in Accesspoint on Refresh

Peter_Cammaert — Thu, 29 Jun 2017 14:58:04 GMT

In the user interface, QlikView must have a reason to re-evaluate an expression. If nothing changes in the expression context, your expression won't be re-evaluated. Try with an expression like =Rand()*Now() and you'll see what I mean (but do not use that one in a final document as Now() is known to put a high load on your client)

If you only need a change once after every reload, why don't you calculate a new random value in your LOAD Script?