show only those rows which has 0 values in two out of three columns

[Sulafah]

Hi,

I have attached my Pivot table,

In this table I want to show only those rows that have '0' value in all three columns or have '0' value in two out of three columns.

like 7=0, 8=0, 9=0 or 7,8=0 or 7,9=0 or 8,9=0

according to my requirement

only record 6025, 6026, 6029, 6032, 6037 and 6043 should be displayed, please see the attached picture.

Best Regards,

Faisal

[jmartineze]

Hello, you can use set analysis or expresion like this if(YourExpresion=0,YourExpresion)

J.

[Sulafah]

if I write expression like you mentioned, it shows all the records that has '0' values in every column, but I want to show those records as well that has '0' in any of two column and 'non-zero' in the third one.

[jmartineze]

can you attach the qlikview file?

[Sulafah]

I am using personal free edition, if I send you file will you be able to open it ?.

[jmartineze]

yes

[Sulafah]

I am attaching file, but I am a newbie and made a lot of mess into it 🙂

[jmartineze]

Hello, 

I think this is the expresion you need

Sum({<Articles={ 6025, 6026, 6029, 6032, 6037 , 6043 }>}INV_QtyIN)-Sum({<Articles={ 6025, 6026, 6029, 6032, 6037 , 6043 }>}INV_QtyOUT)

Or maybe you  prefer this other

if(Sum({<Articles={ 6025, 6026, 6029, 6032, 6037 , 6043 }>}INV_QtyIN)-Sum({<Articles={ 6025, 6026, 6029, 6032, 6037 , 6043 }>}INV_QtyOUT)=0,
Sum({<Articles={ 6025, 6026, 6029, 6032, 6037 , 6043 }>}INV_QtyIN)-Sum({<Articles={ 6025, 6026, 6029, 6032, 6037 , 6043 }>}INV_QtyOUT),
'-') 

Try it.

J.

[Sulafah]

Hi,

Articles cannot be fixed like you mention in set, they change so it is not working like I need.

Regards,

Faisal