topic Re: Re: Re: Random % selection of data sample in QlikView https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703719#M253823 <HTML><HEAD></HEAD><BODY><P>Apparently there isn't an OnClear trigger but a commonly suggested workaround is to add the trigger OnAnySelect and count the current selections.&nbsp; If this is zero then the Clear button has been pressed.&nbsp; I used this to set the variable behind the slider to 100%, see attached</P></BODY></HTML> Wed, 25 Jun 2014 18:22:09 GMT 2014-06-25T18:22:09Z Random % selection of data sample https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703714#M253818 <HTML><HEAD></HEAD><BODY><P>Question for the group on best approach and is it possible? If so how?</P><P>I have an app, with data loaded in memory.</P><P></P><P>I want the end user to be able to randomly select a % sample of the data without reloading it based upon a slider.</P><P></P><P>i.e If The app has 1000 records loaded into memory and the user decides they want a random sample of 30% of the data within the graphs, listboxes etc, they move the slider to 30% and the app selects the random 30% from memory.</P><P>Clicking back/clear resets the records to the full 1000 ...</P><P></P><P>Possible?</P><P></P><P>(I have the ability to do this on load , thanks to help from Gysbert and using Sample (n) already)</P><P></P><P>Robin.</P></BODY></HTML> Wed, 18 Jun 2014 12:55:20 GMT https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703714#M253818 2014-06-18T12:55:20Z Re: Random % selection of data sample https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703715#M253819 <HTML><HEAD></HEAD><BODY><P>Further details (since Robin is helping me with this)</P><P></P><P>Using this article we were able to define a random sample within the app by manually entering an expression into the listbox:</P><P><A href="http://qlikviewmaven.blogspot.com/2010/09/random-sample-selection.html" title="http://qlikviewmaven.blogspot.com/2010/09/random-sample-selection.html">QlikView Maven: Random Sample Selection</A></P><P></P><P>For example, <STRONG style="color: #333333; font-family: Verdana, sans-serif; background-color: #e0e0e0;">=rand()&lt;=0.2+now()*0</STRONG></P><P></P><P>Rather than have to enter this each time, we'd like to have a slider that the user could adjust and have the random sample criteria be applied.&nbsp; Example data is attached.</P><P></P><P>Thanks!</P><P>Ravi</P></BODY></HTML> Wed, 25 Jun 2014 12:54:30 GMT https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703715#M253819 2014-06-25T12:54:30Z Re: Re: Random % selection of data sample https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703716#M253820 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use trigger on a variable linked to a slider. Se attached example.</P><P>This is only working if you clear the account field before you use the slider.</P><P>Didn't get it to clear the field in the trigger... weird.</P><P>Cheers</P></BODY></HTML> Wed, 25 Jun 2014 15:43:28 GMT https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703716#M253820 2014-06-25T15:43:28Z Re: Re: Random % selection of data sample https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703717#M253821 <HTML><HEAD></HEAD><BODY><P>Thanks Martin.</P></BODY></HTML> Wed, 25 Jun 2014 15:58:03 GMT https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703717#M253821 2014-06-25T15:58:03Z Re: Re: Random % selection of data sample https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703718#M253822 <HTML><HEAD></HEAD><BODY><P>Splendid, thanks Martin!</P></BODY></HTML> Wed, 25 Jun 2014 17:39:33 GMT https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703718#M253822 2014-06-25T17:39:33Z Re: Re: Re: Random % selection of data sample https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703719#M253823 <HTML><HEAD></HEAD><BODY><P>Apparently there isn't an OnClear trigger but a commonly suggested workaround is to add the trigger OnAnySelect and count the current selections.&nbsp; If this is zero then the Clear button has been pressed.&nbsp; I used this to set the variable behind the slider to 100%, see attached</P></BODY></HTML> Wed, 25 Jun 2014 18:22:09 GMT https://community.qlik.com/t5/QlikView/Random-selection-of-data-sample/m-p/703719#M253823 2014-06-25T18:22:09Z