Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jhlovenc
Contributor II

Create qvd

What am I doing wrong here?  Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items;  Store Local_Individual_Items INTO  C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd

5 Replies
jhlovenc
Contributor II

Re: Create qvd

OK, So this loads the file Cost_Centers into QVW, but does not create the QVD  Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Cost_Centers;  Store Cost_Centers INTO  C:\Program Files\QlikView\LOCAL\Local_Cost_Centers.qvd (qvd);    SQL SELECT * FROM dw_DataMart.dbo.Dim_Cost_Centers;

nagaiank
Valued Contributor III

Re: Create qvd

Try the following:

Cost_Centers:

LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items; 

Store Cost_Centers INTO  C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd (qvd);

jhlovenc
Contributor II

Re: Create qvd

These are the errors I received:  Cannot open file 'C:\Users\uslovjon\Desktop\dw_DataMart.dbo.Dim_Individual_Items' The system cannot find the file specified.  Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items    Table not found Store Cost_Centers INTO  C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd (qvd)

jhlovenc
Contributor II

Re: Create qvd

CC: LOAD Cost_Center FROM C:\Users\uslovjon\Desktop\CC.xlsx (ooxml, embedded labels, table is Sheet1);  Store CC Into C:\cc.qvd (qvd);   This works fine when I comment out the last line.  When it is in there - I simply get "execution of script failed..."

jhlovenc
Contributor II

Re: Create qvd

CC: LOAD Cost_Center FROM C:\Users\uslovjon\Desktop\CC.xlsx (ooxml, embedded labels, table is Sheet1);  Store CC Into C:\cc.qvd (qvd);