I'm trying to create a button in Qlik Sense that allows a user to select a random value from a list of possible values depending on the values available after filters have been applied. I've seen a few suggested solutions on here via the reload script but needs to be via a button
In the example below, I'd want to filter sales by date in the normal way, which would give me a list of all Part Numbers sold during that period and then select a Part Number at random via a button.
Something like Rand(GetPossibleValues(PartNumber)) or Rand(Concat([PartNumber],','))
(appreciate these aren't right but just to give an idea of what I'm trying to achieve)
I'm hoping that I could get the button to set the above value as a variable and then display in a KPI object
