topic Re: Excluding NULL values in where class in QlikView

Excluding NULL values in where class

sridhar_sigired — Mon, 26 Sep 2016 09:57:40 GMT

Hello,

I have a QVD and in one of the field called "Store" null values are there. I need to exclude those NULL records.

I have tried with below conditions but i cannot able to filter those values. Can anyone help me on this?

Where Store<>' ';

Where Store <> 'NULL ';

tresB — Mon, 26 Sep 2016 09:59:02 GMT

Try like:

Where Len(Trim(Store))>0;

Anil_Babu_Samineni — Mon, 26 Sep 2016 10:01:18 GMT

You can try this too

Where Store;

miguelbraga — Mon, 26 Sep 2016 10:01:45 GMT

Have you tried?

Where Store <> null();

Best regards,

D.A. MB

pradeep_s — Mon, 26 Sep 2016 10:03:26 GMT

Use not IsNull(Store)

Store <> Null()

sridhar_sigired — Mon, 26 Sep 2016 10:03:46 GMT

Thank you all for quick response.

Anil_Babu_Samineni — Mon, 26 Sep 2016 10:09:48 GMT

Srishar, Does Tresesco suggestion is working or not?

sridhar_sigired — Mon, 26 Sep 2016 10:20:13 GMT

His responses always works so i kept his response as helpful and used migual response.