topic Re: null values in QlikView

null values

master_student — Mon, 26 Sep 2016 09:08:02 GMT

Hello guys,

I need to know how to delete null values of an expression not a dimension..

Thanks for your help

Re: null values

trdandamudi — Mon, 26 Sep 2016 09:10:55 GMT

Can you be little bit more specific...Are you looking to hide a column when it null ?

Re: null values

miguelbraga — Mon, 26 Sep 2016 09:11:26 GMT

Hey there,

Try creating a field like this :

if(isnull([you dimension goes here]), 'null', [you dimension goes here]) as MyDimensionWithNullValues,

Then in expression use something like this:

=Sum({$<MyDimensionWithNullValues <> {'null'}>} Sales)

Best regards,

D.A. MB

Re: null values

miguelbraga — Mon, 26 Sep 2016 09:13:15 GMT

1. If you don't want to mess with the script do as following:

=Sum({$<[you dimension goes here] <> null()>} Sales)

2. If that don't solve your problem check the Surpress Null Values in all dimension that you have -> Dimensions Tab

3. If that don't for you create an expression like this:

if(isnull([you dimension goes here]), 0,1) * [your expression goes here]

And then check in expression Supress Zero Values -> Presentation Tab

Do you need more solutions?

Re: null values

Chanty4u — Mon, 26 Sep 2016 09:14:55 GMT

try below

If(Expression <> 0, Expression)

Re: null values

jagan — Mon, 26 Sep 2016 09:14:56 GMT

Hi,

Select Supress Null values option in Presentation tab?

Regards,

Jagan.

Re: null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 09:16:46 GMT

Why not simply suppress when value is null from Presentation Tab?

Re: null values

master_student — Mon, 26 Sep 2016 09:24:21 GMT

yes

Re: null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 09:28:28 GMT

Are you trying this?

If(YourExpession = 0, 0, 1) From Layout Conditional / What?

Re: null values

master_student — Mon, 26 Sep 2016 09:35:12 GMT

it is a filed DATEE that has this format, i need to put in in the expression section :

how to delete '-' values.

Thanks

Re: null values

miguelbraga — Mon, 26 Sep 2016 09:38:01 GMT

Have you saw or tried any of my solutions above?

Re: null values

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

Can you share me your application

Re: null values

master_student — Mon, 26 Sep 2016 09:43:45 GMT

Yes. My expression is '= DATEE' I tried =If(DATEE <> 0, DATEE) / if (is not null (DATEE))

but it didn't work

Re: null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 09:45:55 GMT

Instead of zero try Null()

Re: null values

master_student — Mon, 26 Sep 2016 09:48:17 GMT

no. it doesn't work

If(DATEE <> Null() , DATEE)

Re: null values

miguelbraga — Mon, 26 Sep 2016 09:48:32 GMT

Clearly you didn't read my solution but here it goes...

Try this:

=If(isnull(DATEE), null(), DATEE)

This should give you the ability to see where the null is and only then surpress it in the Presentation Tab

Best regards,

D.A. MB

Re: null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 09:58:24 GMT

I don't think so why is not working, Finally last chance from script.

Sheet1:

LOAD * FROM .....Excel Where DATEE;

Re: null values

sunny_talwar — Mon, 26 Sep 2016 13:49:10 GMT

Do you have other expressions in the field where you are not using the same if function which you use for this particular expression? Also what version of QlikView are you using?