Delete or hide a row when it have a null or specific value

[#1]

Hi, i have make a table, in this table there´s a column whit an expresión that represents the top 10 increase of a value about the last month,

When i apply a filter appers some rows whit null or cero values i whant to know how hide or delete thats row, sorry for mi english.
I attach a screenshoot for example.

[Anonymous]

[#3]

Hi kelly, thanks for the answer, i´m using qlikview, i have marked "delete when null values" in dimensions but it dosen´t work.

[Anil_Babu_Samineni]

We have few options like Suppress when value is null from presentation tab and meantime, You can do same in dimension tab

[Anonymous]

Then I would go into the data load editor and do a WHERE [a field] <>Null(). This will only load rows that have viable data. It goes after the from statement in your load statement.

[#6]

I´ve marked all options in presentation tab and doesn´t found, maybe the solution is in the load editor like that kelly says, thanks!

[Anil_Babu_Samineni]

Seems, You are doing in Front end. I don't think whether you need in Front end or Back end.

What was the expression you use to get data points

[#8]

The expresion is like that :

=IF(ISNULL(

NUM(SUM({<field={'aa','bb','cc'},}field2)/SUM({ < field1={'BBB','AAA','},

- SUM({<} >})/SUM({ < ,'###,##%')

),

NULL(),

NUM(SUM({<

- SUM({)/SUM({ < ),'###,##%')

)

I´ve make a where to dont charge cero values but dosen´t found at all, i want delete the rows when de value are <0 too.

Thanks for the help.

[#9]

i do it but the nulls results appears anyway, maybe the cero or nulls result are make by the expression

[Anonymous]

Maybe but I would try doing the where clause on the column the numbers are in. There are names that go along with them so if you do the (not) <> null with that column you'll still get them. Also try not formatting them as numbers in the expression there should be a way to do it in the data section.