topic Re: How to exclude rows with zero value in an expression? in QlikView

How to exclude rows with zero value in an expression?

joeluqlik — Wed, 15 Nov 2017 22:24:59 GMT

I like to exclude showing all the rows with zero value within an expression in the Diff. column.

In this example, I tried to exclude showing the second (A0002) and third (A0003) lines.

In the real file, there will be a lot of zero Diff lines to exclude.

Order	File1	File2	Diff
A0001	2000	1800	200
A0002	1500	1500	0
A0003	1000	1000	0
A0004	500	600	-100
A0005	0	200	-200
Total	5000	5100	-100

Already put on Suppress Zero-Value for all fields, and can't filter select the zero value within the Diff column which is an expression.

And can't create list box using the Diff expression either.

Please see the attached QVW file, thanks!

sunny_talwar — Wed, 15 Nov 2017 22:34:44 GMT

Check the attached

joeluqlik — Thu, 16 Nov 2017 00:30:40 GMT

Hi Sunny,

That worked, great, thanks so much for your help.

By the way, you mind taking a look at my other question under the 'JL_0002' tag?

Thanks!