Chart Groups data

Tue, 21 May 2013 08:35:09 GMT

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:

(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

topic Chart Groups data in QlikView

Chart Groups data