Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

null values

how to avoid null values in an expression column?

10 Replies
beck_bakytbek
Master
Master

Hi raadwiptec,

check this issue: Show date Dates with 0 value if data not available

that helps to finde solution for your issue, let me know if you need assistance

i hope that helps

beck

jonathandienst
Partner - Champion III
Partner - Champion III

"Avoid" them in what way? Hide them, don't load them, change them to something like "missing" or prevent them? If you ask questions that are a bit more specific, you will get more accurate and useful answers.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
raadwiptec
Creator II
Creator II
Author

either hide them or avoid them in the expression only

raadwiptec
Creator II
Creator II
Author

but nothing at the script level only at the expression level

beck_bakytbek
Master
Master

raadwiptec,

you can use both in Script and in Expression, check above

vishsaggi
Champion III
Champion III

What Chart object you are using here ? Any sample data or App you can attach ?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

If you want Dimension null values to get excluded then go to Dimension Tab and Click on Dimension and Mark the "Suppress When Value is Null"

For Expression,

You should go to Presentation Tab and Mark the option which says "Suppress Zero-Values"

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
raadwiptec
Creator II
Creator II
Author

/dimension i can supress ...but expression iam not able to supresss

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Please share then sample Application, to understand your problem.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!