topic Filter for Null Values in QlikView

Filter for Null Values

Wed, 29 Jul 2015 19:15:11 GMT

Hi,

I was trying to make a filter on my dashboard for whether or not a ticket is assigned to an actor. The function I entered to do this is:

=if(len(trim(actorname))=0,'Unassigned','Assigned')

When I try to apply the filter as Assigned or Unassigned, in the straight table I have displaying the rest of the ticket information, I see both assigned and unassigned tickets. How should I enter the function into the filter so that it truly reflects both assigned and unassigned tickets?

Thanks

Re: Filter for Null Values

MK_QSL — Wed, 29 Jul 2015 20:22:26 GMT

you can do anyone of below

1) Create a Flag in script for Null and NonNull Values

If(Len(Trim(actorname))=0 or IsNull(actorname), 'Unassigned','Assigned') as Flag

Now you can use Flag List box to filter null values using unassigned

2) Create a dummy actorname for Null values

If(Len(Trim(actorname))=0 or IsNull(actorname), 'Dummy',actorname) as actorname

Re: Filter for Null Values

Thu, 30 Jul 2015 11:50:29 GMT

Thank you!