0 Replies Latest reply: Feb 15, 2012 4:22 PM by gbuagbua RSS

    StockOut Dashboard

      Hi Everyone,

       

      Could anyone give a suggestion about the following (I am a novice with Qlikview): A stock out dashboard should be created. There are 5 stores offering a variety of products and the stock out is defined as products that are sold in the particular store (they might not be offered in all the stores) + they have 0 sales in some days.The sales dates data is for 6 month period. I tried with a pivot table with Stores and Products columns and expression to count 0s for the sales dates when a product is not sold, but it didn't work.

       

      Thank you in advance.