topic Re: Generate a set of random key values in QlikView

Generate a set of random key values

hansdevr — Sat, 16 Nov 2024 21:52:40 GMT

Dear members,

I need to generate a list of randomly picked Dossier numbers. Of course, a number of criteria which those numbers must meet, is already known (using a 'where' clause), but then I need to generate a random list, let's say a 100 Dossier numbers from a list of 10,000.

What is the best way of doing this?

Any help would be greatly appreciated!

Thanks,

Regards,

Hans de Vries

Re: Generate a set of random key values

jensmunnichs — Fri, 16 Nov 2018 09:56:48 GMT

Maybe add a random number field to your data using the Rand() function, sort the data using this field (using the Order By clause), then load first 100 using the First load prefix. You'll have to work with temp tables and resident loads though, as you can't do all of this in a single load.

Re: Generate a set of random key values

hansdevr — Fri, 16 Nov 2018 10:06:11 GMT

This might indeed work, Jensmunnichs, thnx! 🙂

Re: Generate a set of random key values

jensmunnichs — Fri, 16 Nov 2018 10:11:09 GMT

No problem 🙂 If the solution works, I'd appreciate it if you came back and marked my answer as correct to close the thread 🙂

Re: Generate a set of random key values

hansdevr — Fri, 16 Nov 2018 10:12:55 GMT

LOL, I assume it will work. I'll work out the technique myself! 🙂

Thanks for your help!