Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

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

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

Tags (3)
3 Replies
alexandros17
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

Miguel_Angel_Baeyens
Not applicable

Re: Store Stament for strait table

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

Re: Store Stament for strait table

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