topic Re: Load error in QlikView

Load error

Thu, 13 Sep 2012 10:08:52 GMT

Can anyone tell me why the

Year(Transactiondate) as Year,

Month (Transactiondate) as Month

is not working in the load statement below. Something similar has worked for me in other QV files but not this one

Transactiondate is in this format dd/mm/yyyy in excel

Thanks

LOAD

[Invoice centre],
[Cost centre],
[Driver name],
[Card number],
[Gross amount],
[Net amount],
[Unit price],
[VAT amount],
Quantity,
[Product Charge description],
Transactiondate,
Year (Transactiondate) as Year,
Month (Transactondate) as Month,
[Supplier invoice number],

[Brand name]

Re: Load error

kamalqlik — Thu, 13 Sep 2012 10:27:58 GMT

Can you share the application here.I think that may be some syntax error.Can you be more specific that what the error message is coming when you are loading .

Regards

Kamal Naithani

Re: Load error

Thu, 13 Sep 2012 10:34:47 GMT

this is the error.

How do I attach a file???

Field not found - <Transacton date>

LOAD [Invoice centre],

[Cost centre],

[Card number],

[Gross amount],

[Net amount],

[Unit price],

[VAT amount],

Quantity,

[Product Charge description],

[Transaction date],

Year ([Transaction date]) as Year,

Month ([Transacton date]) as Month,

[Supplier invoice number],

[Brand name]

Re: Load error

kamalqlik — Thu, 13 Sep 2012 10:38:37 GMT

Hi Friend,

Month (Transactondate) as Month,....This is the error as You are having
[Transaction date] as Field

But when you are using Month ([Transacton date]) as Month, you have made the spelling mistake.

Hope it helps

Regards

Kamal

Re: Load error

Thu, 13 Sep 2012 10:41:46 GMT

Thanks, sometimes you can't see the wood for the trees. All working now