topic Re: Create static data in QlikView

Create static data

Anonymous — Wed, 01 Jun 2011 15:15:04 GMT

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.

Create static data

Wed, 01 Jun 2011 15:17:16 GMT

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

Re: Create static data

Anonymous — Wed, 01 Jun 2011 15:27:22 GMT

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

CODE DESCRIPTION

ACTV Active

TERM Terminated

Re: Create static data

Miguel_Angel_Baeyens — Wed, 01 Jun 2011 15:31:55 GMT

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

Create static data

Anonymous — Wed, 01 Jun 2011 15:47:42 GMT

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.

Re: Create static data

erichshiino — Thu, 02 Jun 2011 01:39:10 GMT

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

Create static data

Anonymous — Thu, 02 Jun 2011 13:05:24 GMT

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

Regards,

Dinesh.