topic How to write this condition in QlikView

How to write this condition

Thu, 06 Apr 2017 02:05:00 GMT

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');

Re: How to write this condition

sunny_talwar — Thu, 06 Apr 2017 15:14:07 GMT

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

Re: How to write this condition

sunny_talwar — Thu, 06 Apr 2017 15:16:30 GMT

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')))))

Re: How to write this condition

Peter_Cammaert — Thu, 06 Apr 2017 15:24:36 GMT

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 ...