How to write this condition

[#1]

  I have created flag fields with the corresponding days. I am trying to create them into compliance flags. I'm not sure where to go from here to get it to work in Qlikview. 

      if(Flag = '0-14 days', 'Compliant'),

     if(Flag = '15-30 days', severity <> 'Critical', 'Compliant', else 'Non Compliant'),

     if(Flag = '31-90 days', severity <> 'Critical', 'High', 'Compliant' else 'Non Compliant'),

     if(Flag = '91+ days', severity <> 'Critical', 'High', Medium', 'Compliant', else, 'Non Compliant');

[sunny_talwar]

Is Flag created in the script or is this a field from the database?

[sunny_talwar · Accepted solution]

May be this

if(Flag = '0-14 days', 'Compliant'),

if(Flag = '15-30 days', If(Not Match(severity, 'Critical'), 'Compliant', 'Non Compliant'),

if(Flag = '31-90 days', If(Not Match(severity, 'Critical', 'High'), 'Compliant', 'Non Compliant'),

if(Flag = '91+ days', If(Not Match(severity, 'Critical', 'High', Medium'), 'Compliant', 'Non Compliant')))))

[Peter_Cammaert]

Or in your script:

MapCompliancy:

MAPPNG LOAD * INLINE [

FlagSeverity, Level

15-30 days|Critical, Non Compliant

31-90 days|Critical, Non Compliant

31-90 days|High, Non Compliant

90+ days|Critical, Non Compliant

90+ days|High, Non Compliant

90+ days|Medium, Non Compliant

];

LOAD ...

     ApplyMap('MapCompliancy', Flag&'|'&severity, 'Compliant') AS ComplianceLevel,

     ...

FROM ...