0 Replies Latest reply: May 21, 2013 4:35 AM by Elisabetta Zunino RSS

    Chart Groups data

    Elisabetta Zunino

      Dear QlikView Community,

       

      I need your help for the following issue.

       

      I Have a list of material code with warehouse quantity and Price.

      I calculated the TurnOver for each material code with Set Analysis.

       

      This is the formula:

      if

      (PlantTotalStock=0,0,sum({$<OutboundDeliveryDate={">=$(=AddMonths(date(date#(ReloadTime,'YYYYMMMDDhhmm'), 'DD/MM/YYYY'), -11))<=$(=ReloadTime)"}>}DeliveryQuantity)/Sum({$}PlantTotalStock))

       

      Now I should create this chart:

       

      Dimension: Turn Over Value (>0, between 0.01 and 1, between 1 and 2, between 2 and 4 acc.......> 12)

      Expression: sum of TurnOver Value*Price

      For clarification see attached image

       

      Is it possible or I need to calculate the TurnOver in the script ?

      Thank you