Create static data

[Anonymous]

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.

[#2]

Please post sample data that you have and how you want to view it on QV

[Anonymous]

I had already done that in the original post. Here it is again:

CODE     DESCRIPTION

ACTV     Active

TERM     Terminated

[Miguel_Angel_Baeyens]

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[Anonymous]

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.

[erichshiino · Accepted solution]

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

[Anonymous]

Sweet. This is very helpful as I did not want to clutter the load script which is already very large.

Regards,

Dinesh.