topic Re: Create qvd in QlikView

Create qvd

Anonymous — Sat, 05 Jan 2013 02:15:03 GMT

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

Re: Create qvd

Anonymous — Sat, 05 Jan 2013 02:34:16 GMT

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;

Re: Create qvd

nagaiank — Sat, 05 Jan 2013 02:36:11 GMT

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);

Re: Create qvd

Anonymous — Sat, 05 Jan 2013 02:44:52 GMT

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)

Re: Create qvd

Anonymous — Sat, 05 Jan 2013 04:19:38 GMT

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..."

Re: Create qvd

Anonymous — Sat, 05 Jan 2013 04:22:25 GMT

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