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: 
Anonymous
Not applicable

Simple Null Select

What is the best way to show transactions where the sales rep is not filled in (Null)? The list box shows null values as '-', but I cannot select it.

Thanks,

Dinesh

1 Solution

Accepted Solutions
Not applicable
Author

You need to trap those null values as exceptions in your load script, try


if(isnull(salesrep),'Unknown Rep',salesrep) as [Sales Rep],


View solution in original post

3 Replies
Not applicable
Author

You need to trap those null values as exceptions in your load script, try


if(isnull(salesrep),'Unknown Rep',salesrep) as [Sales Rep],


boorgura
Specialist
Specialist

In the load script, you can map them to a blank.

if(isnull(RepName), '', RepName) as RepName

That should solve your issue I suppose.

Let me know if it works.

mike_garcia
Luminary Alumni
Luminary Alumni

You can also use Set Analysis, like this:

=Sum({$<TransactionID = {"=IsNull(SalesRep)"}>} Sales)


Regards,

Mike.

Miguel García
Qlik Expert, Author and Trainer