NULLs

[GaneshLakshman]

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

[Vegar · Accepted solution]

Check out isnull()

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

[jonathandienst · Accepted solution]

You can use:

where IsNull(SalesID)
or
where Len(SalesID)