topic StockOut Dashboard in QlikView https://community.qlik.com/t5/QlikView/StockOut-Dashboard/m-p/287065#M1177576 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>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. </P><P></P><P>Thank you in advance.</P></BODY></HTML> Wed, 15 Feb 2012 21:22:49 GMT 2012-02-15T21:22:49Z StockOut Dashboard https://community.qlik.com/t5/QlikView/StockOut-Dashboard/m-p/287065#M1177576 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>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. </P><P></P><P>Thank you in advance.</P></BODY></HTML> Wed, 15 Feb 2012 21:22:49 GMT https://community.qlik.com/t5/QlikView/StockOut-Dashboard/m-p/287065#M1177576 2012-02-15T21:22:49Z