7 Replies Latest reply: Apr 22, 2015 5:05 AM by Ian McGivern RSS

    Stock coverage calculation

      Hi All,

       

      I am new to qlikview, so I am asking for your help to help me solve the following issue :

       

      I have a requirement to calculate stock coverage for any month of year month taking into consideration the following:

       

      data set:

      ProductBrandCountryStock ValueBudget SalesYearMonth
      XAUS10520151
      YAUS20620151
      XAUS15720152
      YAUS25820152


      I want to create a bar chart that shows stock coverage expressed in months of average monthly budgted sales.

      I have different filters in my chart : Year / Month / Brand / Product / Country.

       

      the formula is :  Stock value / (Annual budgeted sales/12).

       

      I want the chart to show for any selected item in the filter, the following:

       

      when Year filter = 2015, month = 2, Brand = A, Product = ALL then

      Stock coverage  = stock value (for year=2015 month =2 Brand =A, Product = ALL) / [(Annual budgeted sales  (for year=2015 month =2 Brand =A, Product = ALL) / 12].

       

      thank you.

       

      Regards.

      Toufik