topic How to remove empty and null values on my table? in QlikView

How to remove empty and null values on my table?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to remove empty and null values on my table?

jaumecf23 — Tue, 17 Apr 2018 09:22:02 GMT

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

Re: How to remove empty and null values on my table?

Anonymous — Tue, 17 Apr 2018 09:25:03 GMT

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

Re: How to remove empty and null values on my table?

jaumecf23 — Tue, 17 Apr 2018 09:29:27 GMT

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

Re: How to remove empty and null values on my table?

jubarrosor — Tue, 17 Apr 2018 09:37:53 GMT

Hello:

In Qlik Sense, you must uncheck this item:

Best Regards,

Juan P. Barroso

Re: How to remove empty and null values on my table?

Anonymous — Tue, 17 Apr 2018 09:56:06 GMT

my be you can use isnull() function

Re: How to remove empty and null values on my table?

Peter_Cammaert — Tue, 17 Apr 2018 10:43:07 GMT

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?