topic Re: Generating Yes/No values in fields in QlikView

Generating Yes/No values in fields

Sun, 01 Sep 2013 17:18:50 GMT

I'm creating data for a demo and trying to generate a Yes or No entry during a load into a bunch of fields in a LOAD. Is there any way do this using rand() or another function? Ideally, I'd like to not have an even distribution of Y/N if that's possible. Thanks!

Re: Generating Yes/No values in fields

swuehl — Sun, 01 Sep 2013 17:49:48 GMT

Yes, you can do it using RAND() function:

LOAD

if( RAND() < 0.3, 'Yes','No') as Answer,

Recno() as AnswerID

Autogenerate 1000;

edit: This creates a 30% chance for a Yes answer (using 0.3). Just compare to different values between 0 and 1 to create other distributions.

Re: Generating Yes/No values in fields

Sun, 01 Sep 2013 18:25:26 GMT

Thanks 'swuehl' - that was exactly what I was looking for!