Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can any one help me out in below issue. The expression is giving error.
count
({<isnull(Refusalcode
)={'-1'} ,act_Typecode={'open'},
SLA_Code={'amber_sla_breach','red_sla_breach','emergency_sla_breached',
'awaiting_parts_sla_breach','emergency_sla_breach','onsite_red_sla_breach',
'onsite_amber_sla_breach'}>}BreachCount)
Regards
Krishna S
Hi
In straight table if(isnull(Refusalcode)=-1,Breachcount) works. I have to add some more conditions as mentioned above. If i use normal if condition, logic is not working fine. so i am using Set Analysis.
I have used below expression. it works fine.
count({<act_Typecode={'open'},SLA_Code={'amber_sla_breach','red_sla_breach','emergency_sla_breached',
'awaiting_parts_sla_breach','emergency_sla_breach','onsite_red_sla_breach',
'onsite_amber_sla_breach'}>}if(isnull(Refusalcode)=-1, BreachCount))
Thanks a lot
Regards
Krishna S
count
({<Refusalcode = {$(=NULL())},act_Typecode={'open'},
SLA_Code={'amber_sla_breach','red_sla_breach','emergency_sla_breached',
'awaiting_parts_sla_breach','emergency_sla_breach','onsite_red_sla_breach',
'onsite_amber_sla_breach'}>}BreachCount)
Hi
Thanks for you fast reply.
I have used this expression in chart. No data found message is displayed.
Regards
Krishna S
Maybe using simple quotes without blanks
Refusalcode={''}
or
Refusalcode={'=$(=null())'}
or you could asign a value in your load script to null values to make easy founding them in expressions
hope this helps
Hi
Both the cases are not working.
Regards
Krishna S
Could you make a straight table with that field and the expression len(Refusalcode) to see how many characters have null values?
About the dimensiom, do it calculated: if(isnull(Refusalcode), 'NULL', Refusalcode)
Hi
In straight table if(isnull(Refusalcode)=-1,Breachcount) works. I have to add some more conditions as mentioned above. If i use normal if condition, logic is not working fine. so i am using Set Analysis.
I have used below expression. it works fine.
count({<act_Typecode={'open'},SLA_Code={'amber_sla_breach','red_sla_breach','emergency_sla_breached',
'awaiting_parts_sla_breach','emergency_sla_breach','onsite_red_sla_breach',
'onsite_amber_sla_breach'}>}if(isnull(Refusalcode)=-1, BreachCount))
Thanks a lot
Regards
Krishna S