Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (3)
1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

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

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

6 Replies
er_mohit
Honored Contributor II

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

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

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

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
Valued Contributor III

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

Hi, please check app attached.

Highlighted
Not applicable

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

Thanks a lot. It works.

Not applicable

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

Thanks a lot. It works.

Not applicable

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

It didn't work.

Thanks

Rgds

Fahad Cader

Group IT

Aitken Spence PLC

Tel: +94 11 2 308 043

Community Browser