Script debuging help

[#1]

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",

[Gysbert_Wassenaar · Accepted solution]

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",

[#3]

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?

[Gysbert_Wassenaar]

Possibly this:

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