topic Re: need help in QlikView

need help

Tue, 22 Apr 2014 08:02:27 GMT

Am applying the below code but i got empty fields in date field i want date so can u plzzz suggest me

find attachment

Calender:

LOAD CAD_Activity_ID,

CAS_Date_Value,

CAM_ID,

CAS_Remarks,

CAS_Status,

CAS_Updated_By,

if (CAS_Updated_Date = (CAS_Value_Type='A'), 'CAS_Updated_Date')as Date1,

if (CAS_Updated_Date = (CAS_Value_Type='T'), 'CAS_Updated_Date')as Date2,

if (CAS_Value_Type='A', 'A')as CAS_Value_Type1,

if (CAS_Value_Type='T', 'T')as CAS_Value_Type2 ,

CAS_Version

FROM

(qvd);

Re: need help

alexandros17 — Tue, 22 Apr 2014 08:05:12 GMT

You are comparing:

CAS_Updated_Date to a boolean value (0 or 1) resulting from the expression: CAS_Value_Type='A'

so if CAS_Updated_Date has a date format it will never be equal to 0 or 1

Hope it helps

Re: need help

bertdijks — Tue, 22 Apr 2014 08:08:30 GMT

I think your formula is not right:

if (CAS_Updated_Date = (CAS_Value_Type='A'), 'CAS_Updated_Date')as Date1,

means:

if date field = true then give then return the date field.

Since the data field does not contain a true or false value it will never return the date.

You probably want to use the following expression:

if (CAS_Value_Type='A', CAS_Updated_Date)as date1

regards,

Bert

Re: need help

lironbaram — Tue, 22 Apr 2014 08:12:00 GMT

LOAD CAD_Activity_ID,

CAS_Date_Value,

CAM_ID,

CAS_Remarks,

CAS_Status,

CAS_Updated_By,

if (CAS_Value_Type='A', CAS_Updated_Date)as Date1,

if CAS_Value_Type='T', CAS_Updated_Date)as Date2,

if (CAS_Value_Type='A', 'A')as CAS_Value_Type1,

if (CAS_Value_Type='T', 'T')as CAS_Value_Type2 ,

CAS_Version

FROM

(qvd);