Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

date type

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);

5 Replies
amit_saini
Master III
Master III

Hi,

do this:

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


Thanks,

AS

sagaraperera
Creator
Creator
Author

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

Untitled.jpg

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);

amit_saini
Master III
Master III

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,

AS

sagaraperera
Creator
Creator
Author

thanks dear

it is work properly

sagara

amit_saini
Master III
Master III

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

Thanks,

AS