topic Re: Store Stament for strait table in QlikView

Store Stament for strait table

Tue, 08 Apr 2014 07:03:06 GMT

Hi,

I need to create a qvd for for a single strait table in QV, but so far have not succeeded.

I think this should be possible?

Can someone send me a simple example how to do it? For example by using table name and ObjectID.

Thanks in advance,

Joni

Re: Store Stament for strait table

alexandros17 — Tue, 08 Apr 2014 07:21:40 GMT

Store doesn't work this way:

you can store a table (loaded in the script) with its fields, so if you have in your chart a list of fields coming from the same table you can store that table, otherwise, if you are showing fields from more tables you should combine (join or concatenate) to store

hjope it helps

Re: Store Stament for strait table

Miguel_Angel_Baeyens — Tue, 08 Apr 2014 07:23:21 GMT

Hi,

If you want to save what you are displaying in the straight table, you either preaggregate in the script, then use the STORE command, or you export to a file once you are viewing the object.

Miguel

Re: Store Stament for strait table

Tue, 08 Apr 2014 07:33:56 GMT

Hi,

Use this simple script at the end of your loading script it will store each table into a qvd with its name.

for i = 0 to 250

LET d = TableName(i);

if isnull(d) then

i = 250

end if

if d <> null() then

store $(d) into $(d).QVD;

end if

Let us know