Auto generate function

[santho_ak]

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!

https://community.qlik.com/blogs/qlikviewdesignblog/2016/01/15/autogenerate-your-data?et=blogs.comme...

[MarcoWedel · Accepted solution]

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]

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]

Thank you guys. Appreciate your help.

[santho_ak]

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.

https://optimalbi.com/blog/2017/11/15/qlik-basics-random-data-generation/