Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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');
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')))))
Is Flag created in the script or is this a field from the database?
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')))))
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 ...