Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create static code translation in a straight table like below:
CODE DESCRIPTION
ACTV Active
TERM Terminated
I do not want to load this as an Inline load or anything to do within the script. Is it possible to create this kind of table when the data is not loaded via script?
Thanks,
Dinesh.
I'd say that if you don't have a long list, you could use valuelist(), pick() and match.
I included your table in an attachment.
Hope it helps,
Erich
Please post sample data that you have and how you want to view it on QV
I had already done that in the original post. Here it is again:
CODE DESCRIPTION
ACTV Active
TERM Terminated
Hello Dinesh,
If I understand you right, it's not possible. All charts rendered in QlikView show values stored in fields (or operations on values stored in them).
If you only want to show that meaning, so the user knows the translation, you can use a text object with that inside.
However, if you need it to make some transformations to your data, you will have to load inline, or from a text file or whatever.
Hope that helps.
BI Consultant
The aim was not to display (else text could have been a solution), but to send data as a feed. Thanks for your confirmation that this was not possible.
Regards,
Dinesh.
I'd say that if you don't have a long list, you could use valuelist(), pick() and match.
I included your table in an attachment.
Hope it helps,
Erich
Sweet. This is very helpful as I did not want to clutter the load script which is already very large.
Regards,
Dinesh.