topic Isnull problem in set analysis in QlikView

Isnull problem in set analysis

krishnacbe — Wed, 05 Sep 2012 10:56:19 GMT

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

Re: Isnull problem in set analysis

Nicole-Smith — Wed, 05 Sep 2012 12:33:20 GMT

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)

Re: Isnull problem in set analysis

krishnacbe — Wed, 05 Sep 2012 12:37:16 GMT

Thanks for you fast reply.

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

Regards

Krishna S

Re: Isnull problem in set analysis

chematos — Wed, 05 Sep 2012 12:42:34 GMT

Maybe using simple quotes without blanks

Refusalcode={''}

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

Re: Isnull problem in set analysis

krishnacbe — Wed, 05 Sep 2012 12:46:22 GMT

Both the cases are not working.

Regards

Krishna S

Re: Isnull problem in set analysis

chematos — Wed, 05 Sep 2012 12:50:07 GMT

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)

Re: Isnull problem in set analysis

krishnacbe — Wed, 05 Sep 2012 12:57:55 GMT

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