Omit Rows where field is NULL Table Box

[Anonymous]

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.

[sunny_talwar]

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

[Chanty4u · Accepted solution]

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

chk below'

Re: Remove null data in load

[rubenmarin]

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()

[Anonymous]

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 ?

[kkkumar82]

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

[Chanty4u]

u can set in scrpit

as

SET NullValue = ' ';

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

[Anonymous]

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)

[rubenmarin]

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):

[Anonymous]

Thanks you for your responses, i find a solution:

i change my SQL formula.

Have a good day,

Sébastien.