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.
