topic Script debuging help in QlikView

Script debuging help

Tue, 13 Nov 2012 09:19:42 GMT

can someone please help try debug this code for me; i tried converting an oracle code to qlikview but its giving syntax errors

If ( (("CHL_SECTION_CDE" = 503 or 501) AND (Floor(("CRL_CLMINC_DATE" - "CHL_START_DATE")/31)) > 24)),'Non Medical',

IF ( (("CHL_SECTION_CDE" = (509 OR 508 OR 500 OR 502 OR 507)) AND (fLOOR(("CRL_CLMINC_DATE" - "CHL_START_DATE")/31)) > 12)), 'Non Medical',

if (("CHL_SECTION_CDE" = 510 AND (FLOOR(("CRL_CLMINC_DATE" - "CHL_START_DATE")/31)) > 3),'Non Medical'))) AS "Medical/NonMedical",

Re: Script debuging help

Gysbert_Wassenaar — Tue, 13 Nov 2012 09:40:54 GMT

Try:

If ((CHL_SECTION_CDE = 503 or CHL_SECTION_CDE =501) AND Floor((CRL_CLMINC_DATE - CHL_START_DATE)/31) > 24,

'Non Medical',

IF ( match(CHL_SECTION_CDE, '509' , '508' , '500' , '502' , '507') AND Floor((CRL_CLMINC_DATE - CHL_START_DATE)/31) > 12,

'Non Medical',

if (CHL_SECTION_CDE = 510 AND FLOOR((CRL_CLMINC_DATE - CHL_START_DATE)/31) > 3,

'Non Medical')

)

) AS "Medical/NonMedical",

Re: Script debuging help

Tue, 13 Nov 2012 09:54:43 GMT

Hi,

That worked just fine thanks a lot,

TRUNC(TO_NUMBER(SUBSTR("CRL_CLM_VIEW"."WORKINGHOURS",1,INSTR("CRL_CLM_VIEW"."WORKINGHOURS",':')-1))/24) As "CrystalDays",

would you have any idea how that oracle code is converted to qlikview?

Re: Script debuging help

Gysbert_Wassenaar — Tue, 13 Nov 2012 11:19:32 GMT

Possibly this:

floor(num(subfield(CRL_CLM_VIEW.WORKINGHOURS,':',1))/24) As CrystalDays