Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to remove empty and null values on my table?

Hello,i have many null and emty values on some columns on my table .i want to remove them.How could i do this?

6 Replies
jaumecf23
Creator III
Creator III

For example in the Dimension Tab, for each Dimension you have an option that is Suppress When Value is Null

Captura.PNG

Anonymous
Not applicable
Author

i don't find this.it's possible with script?

jaumecf23
Creator III
Creator III

I think is not possible in the script. You can find this in your Chart properties:

Captura.PNG

jubarrosor
Partner Ambassador
Partner Ambassador

Hello:

In Qlik Sense, you must uncheck this item:

Best Regards,

Juan P. Barroso

Anonymous
Not applicable
Author

Hi

my be  you can use   isnull()  function

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Tables are usually organised as rectangular groups of rows & columns. You cannot remove cells from this grid as a table doesn't allow holes. You can only replace cell values.

By what value do you want to replace those empty or NULL values?