Item wise store Report required with a given condition

[#1]

Dear All,

I have a requirement where I have some Items having some stocks across different stores.

I have to display those items store wise stock where the stock of that item is -ve in some Stores,but +ve in others stores .

i.e-For Item "a001",its stock in store "s02" is -1,"s04" is -2,but in "s01","s03" are +ve,so I will display that item "a001".

Same logic is applicable for "a002","a003" so I will display those items.

but for item "a004","a005" as their stock in every store is +ve,So I will not display that.

for Item "a006" as its stock across all store are -ve,I will not display that.

PFA my original Data and desired output.

Please help..

[sunny_talwar]

Would you be able to provide the original and desired data in form of an excel file? Images cannot be loaded into QlikView making it difficult for us to type all the original data into a sample application

[#3]

Ok...I am attaching the excels.

[sunny_talwar]

I think all your need is to use a pivot table here:

QlikView | Pivot Tables - YouTube

[#5]

Yes the desired output should be in pivot table.