topic Re: NULLs in App Development

NULLs

GaneshLakshman — Thu, 02 May 2019 04:04:05 GMT

Hi,

I 'm trying to find out the Ids that are null in the data.

in SQL we can say where SalesID is NULL, is there anything similar in Qlik sense?

My other question is if I use Where not exists(salesID), will it eliminate all the records that match with the previous load? and what if there are more than one load prior to this?

Thanks

Re: NULLs

Vegar — Thu, 02 May 2019 04:29:52 GMT

Check out isnull()

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/NULLFunctions/IsNull.htm

Re: NULLs

jonathandienst — Thu, 02 May 2019 06:14:20 GMT

You can use:

where IsNull(SalesID)
or
where Len(SalesID)