Making Blank fields Selectable

[#1]

Hi,

I have a spreadsheet that is filled out by staff and shows the status of items by having a number of columns.

These include the Month, SalesPerson, Customer, Amount, and Status

The status column is my problem as until the item is complete this field is blank.

I want to be able to select the items that are pending (i.e. the blanks in Status column) when brought into Qlikview but blank lines in the pivot table shown by " - " are not selectable.

Is there a way when bringing in a table to give the blank fields a value e.g. "Pending" so that is appears in my Qlikview report as a selectable variable?

Thanks

David

[#2]

Bearing in mind recent discussions on null recognition issues between32/64 bit I would choose:

if (len(Status)=0, 'Pending', Status) as Status

Regards,

Gordon

[#3]

Hi Gordon,

Haven't been reading the forums for a while, so could you link to one of the posts discussing this issue (I guess there are other lazy bastards like me who would like a link instead of having to search ).

Regarding the main thread: checking for a NULL value and replacing it with some 'pending' or similar value is the solution I'd also choose.

With regards,

Martijn ter Schegget

CND Development

[#4]

I always respect honesty Martijn!

http://community.qlik.com/forums/p/16167/62911.aspx#62911