topic Re: Syntax If(match) null in QlikView

Syntax If(match) null

qlikviewaf — Mon, 27 Nov 2017 17:17:06 GMT

Hi Guys,

do you know which is the right syntax?

i need this formula If(Match(FIELD), IS NULL ...

How is null should be written? i tried with IsNull but is not working

Here the full syntax

if (match ((SDURDT),=IsNull),(Date(If(Len(Trim(SDTRDJ))>4,Date(MakeDate(1900+Floor(SDTRDJ/1000))-1+Mod(SDTRDJ,1000))), 'DD/MM/YYYY')),(Date(If(Len(Trim(SDURDT))>4,Date(MakeDate(1900+Floor(SDURDT/1000))-1+Mod(SDURDT,1000))), 'DD/MM/YYYY'))) AS SurgeryDate,

THANK YOU!!

Re: Syntax If(match) null

felipedl — Mon, 27 Nov 2017 18:26:48 GMT

Hi Antonio,

You just forgot about the parenthesis of isNull, it shoulbe isNull(), and would be better to do something like:

(

isNull(SDURDT),

(Date(If(Len(Trim(SDTRDJ))>4,Date(MakeDate(1900+Floor(SDTRDJ/1000))-1+Mod(SDTRDJ,1000))), 'DD/MM/YYYY')),

(Date(If(Len(Trim(SDURDT))>4,Date(MakeDate(1900+Floor(SDURDT/1000))-1+Mod(SDURDT,1000))), 'DD/MM/YYYY'))

) AS SurgeryDate,

Felipe.

Re: Syntax If(match) null

tamilarasu — Mon, 27 Nov 2017 18:36:22 GMT

Hi Antonio,

I can see lot of misplaced brackets and date functions in your formula. Could you please attach a sample file to help you further.

Re: Syntax If(match) null

MarcoWedel — Mon, 27 Nov 2017 22:34:16 GMT

Hi,

one solution might be:

table1:
LOAD RecNo() as ID, *,
    Date(MakeDate(1900+Div(If(SDURDT,SDURDT,SDTRDJ),1000))+Mod(If(SDURDT,SDURDT,SDTRDJ),1000)-1) as SurgeryDate
Inline [
    SDURDT, SDTRDJ
    11111, 12345
    12345,
          , 89001
    90010, 91100
    91100,
    92123, 93234
          , 94345
    94345, 100001
    100001, 110011
          ,
    110111, 117331
    117331, 123456
          , 123456
];

hope this helps

regards

Marco