Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to exclude rows with zero value in an expression?

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.

OrderFile1File2Diff
A000120001800200
A0002150015000
A0003100010000
A0004500600-100
A00050200-200
Total50005100-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!

JL

Tags (1)
1 Solution

Accepted Solutions
Highlighted

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

Check the attached

Capture.PNG

View solution in original post

2 Replies
Highlighted

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

Check the attached

Capture.PNG

View solution in original post

Highlighted
Contributor III
Contributor III

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

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!

JL