Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store Stament for strait table

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

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Miguel_Angel_Baeyens

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

Not applicable
Author

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

next

Let us know