Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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
Thank you guys. Appreciate your help.
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/