Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

null values

Hello guys,

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

Thanks for your help

17 Replies
trdandamudi
Master II
Master II

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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?

MB

Chanty4u
MVP
MVP

try below

If(Expression <> 0, Expression)

jagan
Luminary Alumni
Luminary Alumni

Hi,

Select Supress Null values option in Presentation tab?

Regards,

Jagan.

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
master_student
Creator III
Creator III
Author

yes

Anil_Babu_Samineni

Are you trying this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
master_student
Creator III
Creator III
Author

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

Capture.PNG

how to delete '-' values.

Thanks