excel import - null vs missing value

Tue, 24 Apr 2012 03:29:46 GMT

Hi,

I am importing am excel spreadsheet which was exported from a list in Sharepoint. There is one column 'X' where there are no values i.e NULL.

When I imported the file and created a pivot table, column X showed as having two disctinct values. I played with the presentation layer and discovered that I had 'Missing Symbol' values.

My theory is that someone entered and deleted a value in one of the cells, and it was no longer NULL, but not it was MISSING (according to Qlikview)

To get around this I had to put in the following expression in the load:

trim(if(isnull([field]),'',[field])) as [field]I

I don't like the idea of having to put this logic on every column on the off chance the field has been touched. Am I missing something obvious here? Has anyone else encountered this situation?

excel import - null vs missing value

Tue, 01 May 2012 02:39:21 GMT

I would like to add that this is not an issue until using a pivot table. If you view the field as a list, it will only show the one value, put it into a pivot table and suddenly it is two separate values.

topic excel import - null vs missing value in QlikView

excel import - null vs missing value

excel import - null vs missing value