Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
seanbruton

Randomly select a prize winner from a table

I have a survey been collected and the users are in a field in a table. This list is to be used to generate randomly a winner on the reload of data after the survey window is closed. 

So the survey runs from 19 Jan 2019 to 30 Jan 2019. The Qlik Load script will run to collect the data via API at 31 Jan 2019 @ 01:00.

On this reload once only reload a winner is selected from 163 and increasing.  In Qlik Sense the list of names is created with this expression. 

= if (GetResponses_question = 'Please give us your first and last name to be entered into our prize draw.',GetResponses_answer) 

I was thinking of loading this as a variable in the load script so that it is saved in this reload. Any ideas to get this done? 

 

0 Replies