Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi, I think this will be really simple for those in the know but the easy way eludes me.
Just for fun looking to use a list of ten names (in excel list or inline) and I want too, on a refresh, get a name selected on that list as a random 'Winner'? Only going to schedule for once per month and only for fun.
Any simple load script ideas?
Thanks
give each name ID from 1 to 10. In script, create a random number, assign it to variable and pick a winner like that:
Let vWinner = Ceil(Rand()*10) //this will create a value from 1-10
Then in frontend show Name where it's ID equals the variable vWinner - Only({<ID={$(vWinner)}>}Name)
Winner changes with each reload unless you specify condition
give each name ID from 1 to 10. In script, create a random number, assign it to variable and pick a winner like that:
Let vWinner = Ceil(Rand()*10) //this will create a value from 1-10
Then in frontend show Name where it's ID equals the variable vWinner - Only({<ID={$(vWinner)}>}Name)
Winner changes with each reload unless you specify condition
That worked fine - thanks very much