Isnull problem in set analysis

[krishnacbe]

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

[Nicole-Smith]

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)

[krishnacbe]

Hi

Thanks for you fast reply.

I have used this expression in chart. No data found message is displayed.

Regards

Krishna S

[chematos]

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

[krishnacbe]

Hi

Both the cases are not working.

Regards

Krishna S

[chematos]

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)

[krishnacbe · Accepted solution]

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