topic Re: Problem while reloading. Need help! in QlikView

Problem while reloading. Need help!

Thu, 15 May 2014 06:29:27 GMT

Hi ,

I'm facing a problem while reloading a qvw file. It is loading data from an excel sheet.

This is the excel sheel used.

Reconcilation
Month	Product	Region	Reconcilation Flag	Branch ID	Account ID	Budget	Outlook
1/1/2012	Gold	North	Y	116	69368	1089	3348
1/1/2012	Gold	North	N	115	86559	1560	3099
1/1/2012	Gold	South	Y	117	18091	1982	3867
1/1/2012	Gold	South	N	112	19550	1566	3818

Below is the screenshot of the error I get.

The filed "Month" is present in the spreadsheet. But I don't know why i face that error.

Re: Problem while reloading. Need help!

crusader_ — Thu, 15 May 2014 06:32:58 GMT

Hi there,

If you omit Date(num#(Month)) field everything reloads fine or not?

Andrei

Re: Problem while reloading. Need help!

MK_QSL — Thu, 15 May 2014 06:35:56 GMT

For Date, DateNumber and Month use below in your script..

Date(Date#(Month,'D/M/YYYY')) as Date,

NUM(Date(Date#(Month,'D/M/YYYY'))) as DateNumber,

Month(Date(Date#(Month,'D/M/YYYY'))) as Month

Change D/M/YYYY or M/D/YYYY according to your datefield.

Re: Problem while reloading. Need help!

jonathandienst — Thu, 15 May 2014 06:59:25 GMT

An error in the first field can also mean that QV cannot find the sheet specified, or there are header lines in the sheet that prevent QV from reading the field names.

Check the sheet name.

Your script says header is 1 line - if there is no header line, or more than one, you will also get this error.

HTH

Jonathan