Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Column,
Column
FROM "Table3";
store Table3 into Table3.qvd(qvd);
Any thoughts, ideas, suggestions are greatly appreciated. Thank you.
Try the following script
Table3:
NoConcatenate
SQL SELECT
Column,
Column,
Column,
Column
FROM "Table3";
store Table3 into Table3.qvd(qvd);
Hi,
the data from Table3 is appearing twice because you're loading it twice:
SQL SELECT *
FROM "Table3";
Table3:
Column,
Column,
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
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
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.
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