Solved: Conditions while storing QVD's - Qlik Community

kushalthakral · ‎2015-10-14

Hi All

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

Regards

Kushal Thakral

avinashelite · ‎2015-10-14

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;

View solution in original post

gautik92 · ‎2015-10-14

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

qlikviewwizard · ‎2015-10-14

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 · ‎2015-10-14

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 · ‎2015-10-14

Hi Arjun

i need to store it in Qlikview

Regards

Kushal

gautik92 · ‎2015-10-14

you cannot write thos in store command i hope

kushalthakral · ‎2015-10-14

then any alternative to the same

avinashelite · ‎2015-10-14

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

gautik92 · ‎2015-10-14

what is the scenario ?

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

kushalthakral · ‎2015-10-14

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