topic Re: date type in QlikView

date type

sagaraperera — Mon, 27 Apr 2015 06:23:19 GMT

this is a script in my qvd, in this script include DET_RISK_DATE it is saw to number but i want saw a date type already qvd file DET_RISK_DATE mention was date how to correct this issue.

sagara

Directory;

Loading BCOD,

DET_DEBT_CODE,

DNAME,

EXCODE,

ME_NAME,

DET_REF_2,

DET_POLICY_NO,

DET_RISK_DATE,

DAYS, IF(DAYS<=30,'30_DAYS',IF(DAYS<=60,'60_DAYS',IF(DAYS<=90,'90_DAYS',IF(DAYS<=120,'120_DAYS',IF(DAYS<=150,'150_DAYS',IF(DAYS<=180,'180_DAYS',IF(DAYS>180,'OVER_180',0)))))))AS වයස,

DET_DESCRIP,

DET_PRODUCT,

POL_CLA_CODE,

Leader of Baal

From

ජී: \ qlickviwe \ ගැතිෙයෝ \ DEB_DATA_ASAT_DATE.QVD

(QVD);

Re: date type

amit_saini — Mon, 27 Apr 2015 06:28:14 GMT

Hi,

do this:

Date (DET_RISK_DATE,'MM/DD/YYYY') as DET_RISK_DATE

Thanks,

Re: date type

sagaraperera — Mon, 27 Apr 2015 06:45:14 GMT

Hello amit thanks your response, but it is not work my qlick vew file and script given below

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='Rs#,##0.00;(Rs#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='DD-MM-YY';

SET TimestampFormat='DD-MM-YY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Directory;

LOAD BCOD,

DET_DEBT_CODE,

DNAME,

EXCODE,

ME_NAME,

DET_REF_2,

DET_POLICY_NO,

DET_RISK_DATE,

DAYS,

IF(DAYS<=30,'30_DAYS',IF(DAYS<=60,'60_DAYS',IF(DAYS<=90,'90_DAYS',IF(DAYS<=120,'120_DAYS',IF(DAYS<=150,'150_DAYS',IF(DAYS<=180,'180_DAYS',IF(DAYS>180,'OVER_180',0)))))))AS AGE,

DET_DESCRIP,

DET_PRODUCT,

POL_CLA_CODE,

BAL

FROM

G:\qlickviwe\DEBTORS\DEB_DATA_ASAT_DATE.QVD

(qvd);

Re: date type

amit_saini — Mon, 27 Apr 2015 06:48:26 GMT

Hi,

Try this script: (Copy and paste)

Directory;

LOAD BCOD,

DET_DEBT_CODE,

DNAME,

EXCODE,

ME_NAME,

DET_REF_2,

DET_POLICY_NO,

Date (DET_RISK_DATE,'MM/DD/YYYY') as DET_RISK_DATE,

DAYS,

IF(DAYS<=30,'30_DAYS',IF(DAYS<=60,'60_DAYS',IF(DAYS<=90,'90_DAYS',IF(DAYS<=120,'120_DAYS',IF(DAYS<=150,'150_DAYS',IF(DAYS<=180,'180_DAYS',IF(DAYS>180,'OVER_180',0)))))))AS AGE,

DET_DESCRIP,

DET_PRODUCT,

POL_CLA_CODE,

BAL

FROM

G:\qlickviwe\DEBTORS\DEB_DATA_ASAT_DATE.QVD

(qvd);

Thanks,

Re: date type

sagaraperera — Mon, 27 Apr 2015 06:53:07 GMT

thanks dear

it is work properly

sagara

Re: date type

amit_saini — Mon, 27 Apr 2015 06:56:14 GMT

Glad to help you, please close the thread by marking correct or helpful answer.

Thanks,