topic Expression in QlikView

Expression

deepakqlikview_123 — Mon, 07 Apr 2014 10:45:54 GMT

Hello all,

Can you please tell me how below expression will work.

if(isnull(DATE_OF_OFFLINE)=0,('MBX000'&CHASSIS_NUMBER)) as ASSM_CHASSIS_NUMBER,

Thanks,

Deepak

Mon, 07 Apr 2014 10:49:55 GMT

As per your expression

DATE_OF_OFFLINE is not null then 'MBX000'&CHASSIS_NUMBER this data will store as ASSM_CHASSIS_NUMBER

Isnull() --> True ---> returns --> -1

--> False ----> returns --> 0