Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kushalthakral
Contributor II

Conditions while storing QVD's

Hi All

Can we put some conditions while writing storing a table into QVD or any other alternative to the same.

Regards

Kushal Thakral

1 Solution

Accepted Solutions

Re: Conditions while storing QVD's

see if you have same column names then it wil automatically concatenate with the previous table.

so try like this , either use NoConcatenate key word before the new table or rename all the field of new table .

A:

LOAD A,

flag

from A;

NoConcatenate

B:

LOAD A,

flag

resident A

where flag=0;

19 Replies
gautik92
Valued Contributor III

Re: Conditions while storing QVD's

what condition you want to write?can yu breif little more

Arjunarao
Honored Contributor II

Re: Conditions while storing QVD's

Hi Kushal,

While storing in the sense, we can use where conditions and other filter conditions in script. We can store that table in QVD. Hope you got it. Thank you.

kushalthakral
Contributor II

Re: Conditions while storing QVD's

Hi

Conditions like where like what we write in case of Loading a table same can we apply while writing Store.

Regards

Kushal Thakral

kushalthakral
Contributor II

Re: Conditions while storing QVD's

Hi Arjun

i need to store it in Qlikview

Regards

Kushal

gautik92
Valued Contributor III

Re: Conditions while storing QVD's

you cannot write thos in store command i hope

kushalthakral
Contributor II

Re: Conditions while storing QVD's

then any alternative to the same

Re: Conditions while storing QVD's

With the STORE key word we cannot write any where condition, whiling building the table only you need to specify the same

gautik92
Valued Contributor III

Re: Conditions while storing QVD's

what is the scenario ?

you can write the where in load statement for which you are creating qvd

kushalthakral
Contributor II

Re: Conditions while storing QVD's

Scenario is like i have records in table with flag field containing 0 and 1 but while storing it into QVD i need only those having Flag 0

Regards

Kushal

Community Browser