topic Re: Trying to create a QVD in QlikView

Trying to create a QVD

Fri, 02 May 2014 21:46:35 GMT

Hello All,

I am new to QV and have seen a couple of quick videos that show how to create a qvd. It seems extremely easy to create but for some reason when I enter:

store TableName into Tablename.qvd(qvd);

2 things are occuring:

1) the data for that table loads twice

2) a QVD file is NOT created

The videos that I saw show 2 ways to create the qvd: from a text file and from the data source. I am loading from the data source.

I am naming the table at the top of the script and adding the qvd part of the query (above) into the script.

The only difference that I see on my screen from what I see on the tutorial screens is that my script reads:

(the text in the parenthesis is obviously not in my script, it is just notes for the reader)

(the normal settings here)

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

(theirs does not have this section but mine does)

ODBC CONNECT TO [Views];
SQL SELECT *
FROM "Table1";

SQL SELECT *
FROM "Table2";

SQL SELECT *
FROM "Table3";

ODBC CONNECT TO Views];

(then this)

Table3:

Column,

Column

FROM "Table3";

store Table3 into Table3.qvd(qvd);

Any thoughts, ideas, suggestions are greatly appreciated. Thank you.

Re: Trying to create a QVD

nagaiank — Fri, 02 May 2014 22:26:28 GMT

Try the following script

Table3:

NoConcatenate

SQL SELECT

Column,

Column

FROM "Table3";

store Table3 into Table3.qvd(qvd);

Re: Trying to create a QVD

jaimeaguilar — Fri, 02 May 2014 22:38:57 GMT

Hi,

the data from Table3 is appearing twice because you're loading it twice:

SQL SELECT *

FROM "Table3";

Table3:

Column,

Column

FROM "Table3";

Also there is no need to repeat this line

ODBC CONNECT TO [Views];

You just need to create a single connection string per datasource. About the Store statement make sure the table is written exactly the same in the table and in the store statement, also check that you are allow to write in the folder where you want to create the qvd (just in case). Your store statement is correct, so just check the name of the table and the writting permission,

regards

Re: Trying to create a QVD

maxgro — Sat, 03 May 2014 07:36:18 GMT

start with one table

DIRECTORY;

ODBC CONNECT TO [Views];

Table1:

SQL SELECT *

FROM "Table1";

store Table1 into Table1.qvd (qvd);

check result (qvd created, ctrl-t for table viewer) and then add others tables

DIRECTORY;

ODBC CONNECT TO [Views];

Table1:

SQL SELECT *

FROM "Table1";

store Table1 into Table1.qvd (qvd);

// no need to connect if the db source is the same; qlik uses the last one

Table2:

Noconcatenate // to prevent automatic concatenation if table1 and table2 have the same fields

SQL SELECT *

FROM "Table2";

store Table2 into Table2.qvd (qvd);

Table3:

Noconcatenate

SQL SELECT *

FROM "Table3";

store Table3 into Table3.qvd (qvd);

check 3 tables, 3 qvd

some help LOAD data into QlikView

Re: Trying to create a QVD

Wed, 07 May 2014 15:41:14 GMT

Thank you Nagaian, Jaime, & Massimo. I also read a few articles and received a bit of other help. I'm not 100% sure what the exact problem was but it was resolved. I had actually created a qvd and didn't realize it. It had been saved in a location that I had not known it was saved in. It looks like I did create it but what I further learned was how to save it to where you want it to be saved. I think the process, although very simple, is a bit obscure because when you're saving you don't get a dialogue box prompting you to save to the location that you want to save in and then there is also no confirmation that the qvd was actually created. I now know how to create and read from a qvd. Thanks so kuch for your responses as I learned more about other things from the responses as well.

Re: Trying to create a QVD

Wed, 07 May 2014 15:42:07 GMT

Hello Nagaian,

Can you please tell me what the NoConcatenate is used for and under what circumstances it should be inserted into the script?

Thank you,

Fernando