topic Re: Delete or hide a row when it have a null or specific value in QlikView

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

Tue, 13 Jun 2017 14:46:43 GMT

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.

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

Anonymous — Tue, 13 Jun 2017 14:49:24 GMT

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

Tue, 13 Jun 2017 14:52:40 GMT

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

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

Anil_Babu_Samineni — Tue, 13 Jun 2017 14:56:20 GMT

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

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

Anonymous — Tue, 13 Jun 2017 14:56:22 GMT

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.

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

Tue, 13 Jun 2017 15:02:47 GMT

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!

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

Anil_Babu_Samineni — Tue, 13 Jun 2017 15:04:37 GMT

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

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

Tue, 13 Jun 2017 15:13:09 GMT

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.

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

Tue, 13 Jun 2017 15:22:13 GMT

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

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

Anonymous — Tue, 13 Jun 2017 15:28:35 GMT

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.

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

Anil_Babu_Samineni — Tue, 13 Jun 2017 15:32:12 GMT

You can exclude them with in set operator itself. Can you share sample application to do that?