Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnacbe
Partner - Specialist III
Partner - Specialist III

Isnull problem in set analysis

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

1 Solution

Accepted Solutions
krishnacbe
Partner - Specialist III
Partner - Specialist III
Author

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

View solution in original post

6 Replies
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
Partner - Specialist III
Partner - Specialist III
Author

Hi

Thanks for you fast reply.

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

Regards

Krishna S

chematos
Specialist II
Specialist II

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
Partner - Specialist III
Partner - Specialist III
Author

Hi

Both the cases are not working.

Regards

Krishna S

chematos
Specialist II
Specialist II

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
Partner - Specialist III
Partner - Specialist III
Author

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