Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello, you can use set analysis or expresion like this if(YourExpresion=0,YourExpresion)
J.
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.
can you attach the qlikview file?
I am using personal free edition, if I send you file will you be able to open it ?.
yes
I am attaching file, but I am a newbie and made a lot of mess into it 🙂
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.
Hi,
Articles cannot be fixed like you mention in set, they change so it is not working like I need.
Regards,
Faisal