topic Making Blank fields Selectable in QlikView

Making Blank fields Selectable

Tue, 02 Jun 2009 07:56:52 GMT

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

Making Blank fields Selectable

Tue, 02 Jun 2009 15:37:12 GMT

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

Making Blank fields Selectable

Tue, 02 Jun 2009 15:41:23 GMT

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

Making Blank fields Selectable

Tue, 02 Jun 2009 15:48:24 GMT

I always respect honesty Martijn!

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