Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter non zero values from an expression result

Hi

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

1 Solution

Accepted Solutions
er_mohit
Master II
Master II

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

View solution in original post

6 Replies
er_mohit
Master II
Master II

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

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

Hi, please check app attached.

Not applicable
Author

Thanks a lot. It works.

Not applicable
Author

Thanks a lot. It works.

Not applicable
Author

It didn't work.

Thanks

Rgds

Fahad Cader

Group IT

Aitken Spence PLC

Tel: +94 11 2 308 043