topic Re: Omit Rows where field is NULL Table Box in QlikView

Omit Rows where field is NULL Table Box

Anonymous — Tue, 19 Apr 2016 08:09:12 GMT

Hello,

I am a beginner on Qlikview and i would like suppress all lines where the values of my dimension (here STE) is NULL

I try to select the option "Omit Rows Where Field is Null" on this field but it doesn't works.

Have you got a idea of the problem ?

Thanks in advance for your help,

Sébastien.

Re: Omit Rows where field is NULL Table Box

sunny_talwar — Tue, 19 Apr 2016 08:10:51 GMT

This seems like a table box object and are you referring to 0 as being null? Because I don't see any nulls in the image

Re: Omit Rows where field is NULL Table Box

Chanty4u — Tue, 19 Apr 2016 08:15:31 GMT

u can create in backend script for perticular fields if u knw the data is null

chk below'

Re: Remove null data in load

Re: Omit Rows where field is NULL Table Box

rubenmarin — Tue, 19 Apr 2016 08:20:12 GMT

Hi Sébastien, maybe you can try doing it with a simple table chart. This chart has an option to "Supress Zero Values" in presentation tab.

A value is Null() when it has no value, and zero is a value (and an empty space is also a value), so it's not Null()

Re: Omit Rows where field is NULL Table Box

Anonymous — Tue, 19 Apr 2016 08:57:47 GMT

Thanks you for all your advise,

I try to do a Straight Table with STE field, then i select the option "Suppress Missing" and "Suppress Zero-Values" but it doesn't work:

I also try the "IS NOT NULL" in my SQL code, but it doesn't work too 😕

have you got a idea ?

Re: Omit Rows where field is NULL Table Box

kkkumar82 — Tue, 19 Apr 2016 09:06:42 GMT

Can you post a sample app, what are the other expressions you have other than Sum(STE)

Re: Omit Rows where field is NULL Table Box

Chanty4u — Tue, 19 Apr 2016 09:10:15 GMT

u can set in scrpit

SET NullValue = ' ';

NullAsValue *; // You can give the listed field names instead of * (All fields)

Re: Omit Rows where field is NULL Table Box

Anonymous — Tue, 19 Apr 2016 09:20:26 GMT

Hi Sébastien,

Could you use the below if condition in a "text object" and try to select the row which has a null value and see if the text object is showing the correct value. This is just to be sure that it is a null and not an empty space.

=if(isnull(STE),YES,NO)

Re: Omit Rows where field is NULL Table Box

rubenmarin — Tue, 19 Apr 2016 09:26:33 GMT

Maybe STE!=0... it has a decimals, empty spaces or something, I will need a sample to check what's happening

I tried this script:

LOAD * INLINE [
Dim1, Dim2, STE
A, A, 1
A, B, 0
B, A, 1
];

And returns this table (it removes the zero):

Re: Omit Rows where field is NULL Table Box

Anonymous — Tue, 19 Apr 2016 11:48:04 GMT

Thanks you for your responses, i find a solution:

i change my SQL formula.

Have a good day,

Sébastien.