Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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

jubarros
Luminary Alumni
Luminary Alumni

Hello:

In Qlik Sense, you must uncheck this item:

Best Regards,

Juan P. Barroso

arunaerra
Partner
Partner

Hi

my be  you can use   isnull()  function

Peter_Cammaert

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?