Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

thonipad
Contributor III

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

Simple Null Select

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


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


3 Replies
Not applicable

Simple Null Select

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


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


boorgura
Valued Contributor

Simple Null Select

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
Contributor III

Simple Null Select

You can also use Set Analysis, like this:

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


Regards,

Mike.