topic Re: Auto generate function in QlikView

Auto generate function

santho_ak — Fri, 07 Sep 2018 19:34:22 GMT

Hello,

Is there any script to load something like this in a column.

Column 'Status' should have random values like 'Received', 'Approved', 'Pending', 'Denied'.

Thanks in advance. !

Attached qvf . Tried out Mapping & Pick in script. Getting error, help would be highly appreciated. Thanks!

MarcoWedel — Fri, 07 Sep 2018 22:20:35 GMT

Hi,

you used the wrong quotation marks to name the mapping table in the ApplyMap function.

The correct ones are Chr(39).

Another thing is, that you cannot drop the field "Map" as this is the mapping table name instead of a field.

hope this helps

regards

Marco

rwunderlich — Fri, 07 Sep 2018 22:23:03 GMT

It looks like you copy/pasted from the blog post and got backticks instead of single quote around 'map'. It should be:

ApplyMap('Map',Ceil(Rand()*4)) AS Status

-Rob

santho_ak — Fri, 07 Sep 2018 22:49:19 GMT

Thank you guys. Appreciate your help.

santho_ak — Fri, 07 Sep 2018 22:52:12 GMT

Just in case, if someone looking for addition help to auto generate data. Please use ctrl+0+0, it will generate Qlik script with random data.