topic Re: How to filter non zero values from an expression result in QlikView

How to filter non zero values from an expression result

Wed, 31 Jul 2013 11:51:32 GMT

I have the following fields in the Chart (Straight Table),

e.g.

Expression Expression Expression

using using using

Set Analysis Set Analysis Set Analysis

value between value between AA set Analysis -

2 dates 2 dates BB set Analysis

Invoice_Num Amount (AA) Payment_Amount (BB) NET_AMT

A1 1000.00 500.00 500.00

B1 2000.00 2000.00 0.00

C1 3000.00 1500.00 1500.00

I want to show records where the NET_AMT is not zero, i.e. only show Invoice number A1 and C1. How can I do this.

Thanks in advance.

Rgds

Fahad

er_mohit — Wed, 31 Jul 2013 12:12:34 GMT

you have to write for both column AA and BB is

if(column(3)=0,expression for Column AA)

same for Column BB

and make sure check on Suppress Zero Value in Presentation Tab

Wed, 31 Jul 2013 13:13:22 GMT

Try to click on the search button of the list box. Then for not its <>. Im not sure if it works with <>0 or if you have to write <>0.00. Just try it.

jvitantonio — Wed, 31 Jul 2013 17:19:32 GMT

Hi, please check app attached.

Thu, 01 Aug 2013 03:59:32 GMT

Thanks a lot. It works.

Thu, 01 Aug 2013 03:59:51 GMT

Thanks a lot. It works.

Wed, 07 Aug 2013 06:10:21 GMT

It didn't work.

Thanks

Rgds

Fahad Cader

Group IT

Aitken Spence PLC

Tel: +94 11 2 308 043