How to use distinct funtion

[bushpalaamarnat]

In qlikview, i have created two table, one table which showing the details of out of stock(OOS) where as in the other table, we have summary. the problem is in the details table, there are 6 OOS where as in summary table, it is showing 9 as a count.

This is the formula used to count OOS. Sum(if(Inventory_Position='OOS',1,0))

Could you help. attaching a word document with details.

Kindly help, please see attachment

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc]&ActionItem)