topic Simple Null Select in QlikView

Simple Null Select

Anonymous — Fri, 02 Jul 2010 16:39:49 GMT

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

Fri, 02 Jul 2010 18:01:29 GMT

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


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

boorgura — Fri, 02 Jul 2010 18:16:07 GMT

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 — Fri, 02 Jul 2010 19:43:53 GMT

You can also use Set Analysis, like this:

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

Regards,

Mike.