Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Store Stament for strait table


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,


Tags (3)
3 Replies
Not applicable

Re: Store Stament for strait table

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

Not applicable

Re: Store Stament for strait table


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.


Not applicable

Re: Store Stament for strait table


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