topic Re: Select random value in QlikView

Select random value

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

Guys,

I have a table that contains 17 tips for users. The table has an ID and a Tip (Text). I want to have a text object that randomly displays on of the tips.

I don't care if the system randomly selects a Tip based on a user logging in or randomly selects a Tip a load to display to everyone that logins in until the next refresh when a different Tip is randomly selected by the load.

This sounds pretty straight forward, but I haven't been able to make it work.

Thanks for any suggestions that you might have.

Re: Select random value

swuehl — Sat, 27 Jan 2018 20:34:16 GMT

A variable at load time

Let vRand = Ceil(RAND()*17);

and a text box with

=Only({<TipID = {$(vRand)}>} Tip)

should do what you want.

(instead of creating the variable during load, you can probably also use an OnOpen trigger action)

Re: Select random value

brf10043 — Sat, 27 Jan 2018 21:10:01 GMT

That did it! Thanks !

Re: Select random value

Ehsan1 — Wed, 03 Nov 2021 02:14:35 GMT

I have a list containing unique code and name
I want to select one or more names randomly
Thank you for your help