Discussion Board for collaboration related to QlikView App Development.
Hello,i have many null and emty values on some columns on my table .i want to remove them.How could i do this?
For example in the Dimension Tab, for each Dimension you have an option that is Suppress When Value is Null
i don't find this.it's possible with script?
I think is not possible in the script. You can find this in your Chart properties:
In Qlik Sense, you must uncheck this item:
Juan P. Barroso
my be you can use isnull() function
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?