topic Re: store qvd in QlikView

store qvd

adamgaox — Fri, 20 Nov 2015 05:27:08 GMT

I see two ways of storing table into qvd files

1.STORE TAB INTO tab.qvd;

2.STORE TAB INTO tab.qvd(qvd);

is there any differences between these two methods?

Re: store qvd

simospa — Fri, 20 Nov 2015 09:17:53 GMT

Hi,

from the Documentation, this is the sintax of STORE statement:

store[ *fieldlist from] table into filename [ format-spec ];

format-spec ::= ( ( txt | qvd ) )

SO you can use (txt) or (qvd). If format-spec is omitted, (qvd) is used.

So we can assume that if you want store in a qvd, it's the same thing.

Re: store qvd

tamilarasu — Fri, 20 Nov 2015 09:22:53 GMT

Hi Adam,

Also note that, While loading the QVD into Qlikview, you should not omit (qvd). If you do so, you will get an error popup.

Correct:

LOAD * FROM tab.qvd (qvd);

Wrong:

LOAD * FROM tab.qvd; (You will get an error)

Re: store qvd

Peter_Cammaert — Fri, 20 Nov 2015 09:23:24 GMT

No.

Re: store qvd

Kushal_Chawda — Fri, 20 Nov 2015 09:43:33 GMT

There is no difference between them. You can choose either of them.

Bur generally we use STORE TAB INTO tab.qvd;

Re: store qvd

t_chetirbok — Fri, 20 Nov 2015 09:59:45 GMT

Hi! There are other formats that can be written (txt,csv,qvd) but QVD is the default so the statement works without the suffix.

Re: store qvd

ramasaisaksoft — Fri, 20 Nov 2015 10:17:44 GMT

Hi Adam,

1.STORE TAB INTO tab.qvd;

2.STORE TAB INTO tab.qvd(qvd);

both will gave the same result

but in second query u can save like

STORE TAB INTO tab.qvd(txt); it is also gave same result

i.e (QVD)/(txt) in which format u need to save that is ur wish else by default it is saved qvd format

hope i reach clear your doubt 80 % any way u can try once

Re: store qvd

Anonymous — Fri, 20 Nov 2015 10:49:31 GMT

Hi Adam

giving defining file type for QVD is not mandatory because QlikView understand it.

But when your will store into some txt format like CSV you need to give file type.

ex.

STORE B into B.qvd;
STORE B into B.qvd(QVD);

Above both statements are same.

but below are different.

if you will use (txt) QV will load correct data but when you will not specify the format it will jot load data correctly it will be considered in xml format.

STORE B into csvB.csv(txt);
STORE B into wthoutcsvB.csv;

Thanks

BKC