topic chart with running sum and % in QlikView

chart with running sum and %

lucarizziero — Fri, 31 Aug 2012 15:36:06 GMT

Hi,

I have the following data

I’d need to obtain a chart containing for each customer+month the % of the total qty in the year.

For instance:

the Line Chart will have x=month and y=customers with 2 lines representing the % column

Thanks

whiteline — Fri, 31 Aug 2012 15:50:27 GMT

Create straight-table chart with two dimensions (customer, month) and try these expressions:

Running qty =rangesum(above(Sum(qty),0,rowno()))

Total qty per Customer =SUM(total<customer> qty)

% = rangesum(above(Sum(qty),0,rowno()))/SUM(total<customer> qty)

lucarizziero — Fri, 31 Aug 2012 16:03:04 GMT

It works !:

Thanks a lot