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: 
Sulafah
Contributor
Contributor

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

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

Labels (1)
8 Replies
jmartineze
Partner - Creator
Partner - Creator

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

 

J.

Sulafah
Contributor
Contributor
Author

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
Partner - Creator
Partner - Creator

can you attach the qlikview file?

Sulafah
Contributor
Contributor
Author

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

jmartineze
Partner - Creator
Partner - Creator

yes

Sulafah
Contributor
Contributor
Author

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

jmartineze
Partner - Creator
Partner - Creator

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
Contributor
Contributor
Author

Hi,

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

 

Regards,

Faisal