topic Re: '' AS ID: Returning values instead of Nulls in QlikView

'' AS ID: Returning values instead of Nulls

helen_pip — Tue, 21 Jan 2014 14:42:51 GMT

Hello

I have 3 QVW's, not all of which contain the same field names:

Main

Eye

MIU

Each QVW is stored into a QVD

In a seperate QVW, I load each QVD and concatenate the information together

I am in the process of trying to optimise my QVD's, so I am adding in additional fields dummy fields, to ensure every QVW has the exact same field names

I wish for these additional fields to just contain no data. I have noticed though, that if I do a count on a dummy field, and all I wanted was a null value

How do I build a dummy field to contain null values?

Kind Regards

Helen

Re: '' AS ID: Returning values instead of Nulls

marcus_malinow — Tue, 21 Jan 2014 14:44:56 GMT

Hi Helen,

you can simply use the Null() statement, for example

Null() as NullField

Marcus

Re: '' AS ID: Returning values instead of Nulls

helen_pip — Tue, 21 Jan 2014 15:01:38 GMT

Hello

Thank you! This works for me

Thanks

Helen