topic How to Optimize and remove if statement in QlikView

How to Optimize and remove if statement

Fri, 24 Jan 2014 10:12:23 GMT

=if(WildMatch(UrgencyID,'*CRITICAL -*') and ([Close Date]-[Open Date])=0 ,'Under SLA',

if(WildMatch(UrgencyID,'*HIGH*') and ([Close Date]-[Open Date])>=1,'SLA LOW Priority',

if(WildMatch(UrgencyID,'*MEDIUM*') and ([Close Date]-[Open Date])>=3 ,'SLA MEDIUM PRIORITY',

if(WildMatch(UrgencyID,'*LOW*') and ([Close Date]-[Open Date])>=5 ,'SLA HIGH PRIORITY'

'SLA MISSED'))))

in above script i want to remove if and optimize using other mean (eg. set analysis).

Thanx.

Message was edited by: rahul b

sujeetsingh — Fri, 24 Jan 2014 10:21:43 GMT

Rahul,

one thing you can do is that you can calculate these condition in your script as flag

For example

You can calculate ([Close Date]-[Open Date]) in script and name it as DateDiff.

And then in UI you can use this Flag in your expression if possible you can go in the same way for the other caonditions too

Tue, 18 Mar 2014 10:07:21 GMT

thanx

maxgro — Tue, 18 Mar 2014 10:26:17 GMT

best optimization is almost always put the logic at the script level