Selecting Random Values from a Column

Fri, 20 Nov 2020 18:02:30 GMT

Hello, I'm trying to see if there is a way to select and concatenate random values from columns in QlikView. More specifically:

we have a QlikView file that contains information on over 100K people. Each person has a unique ID number. We have a DEMO view that contains real data but displays fake names. What I typically do to support this view is import a spreadsheet that has random variations on First/Last names linked to all ID numbers. Here's an example:

The problem is that our list of real names is always changing and I am constantly re-calculating these "Fake Name" spreadsheets.

Is there an easier way to accomplish this? What I would love to be able to do is to import a list of Fake First Names and Fake Last Names and run a script in QlikView that selects a random Fake First Name and concatenates it with a random Fake Last Name.

Any ideas?

Re: Selecting Random Values from a Column

giakoum — Tue, 03 Feb 2015 15:56:19 GMT

why don't you use scramble instead?

Re: Selecting Random Values from a Column

alexandros17 — Tue, 03 Feb 2015 15:56:43 GMT

Look for scramble instruction, it can solve your problem

go to

Settings -> document properties -> scrambling

Let me know

topic Re: Selecting Random Values from a Column in QlikView

Selecting Random Values from a Column

Re: Selecting Random Values from a Column

Re: Selecting Random Values from a Column