Formulas no longer working on QV 11

Wed, 21 Mar 2012 19:57:13 GMT

Hi,

I am trying to load information from an excel file(.xlsx), and I have formatted some of the contents, but found the following formulas no longer working on the new QV 11.

Day
Month
Year
Isnull
Date

The following is my script.

LOAD b2_num,

b3_num,

text(mid(b3_num,7,8)) as CREFNO,

b2_submit,

date(das_date) as 'das date',

refund_amt,

cheque_dat,

cheque_num,

cancelled,

date(cancelled) as 'cancel date',

day(cancelled) as 'cancel day',

month(cancelled) as 'cancel month',

year(cancelled) as 'cancel year',

isnull(cancelled) as 'datenull',

reject_dat,

resub_date,

b3_date,

auditor,

client_ref,

expl,

justify,

submitted

FROM

(ooxml, embedded labels, table is mmi8);

but the output does not come out the way it was in QV 10.

Would you please help?

Thanks.

Sharon

Formulas no longer working on QV 11

Wed, 21 Mar 2012 21:34:16 GMT

Figured it out, it was because of the date format.

Thanks.

Sharon

topic Formulas no longer working on QV 11 in QlikView

Formulas no longer working on QV 11

Formulas no longer working on QV 11