Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to do a diagram showing:
based on the selected YearMonth(s),
the number of customers that have been created per month up until that month.
So for example:
Jan 2011: 3 customers are created
Feb 2011: 4 customers are created
March 2011: 5 customers are created
If the months Feb and March are selected I want the diagram to show that in Feb 4 customers were created and in March 9 customers were created. My diagram is currently showing 4 in Feb and 5 in March.
Should I use a set analysis?
Thankful for any help!
Go to Solution.
just use the accumulation feature in the properties of your chart:
i also tried this and that works ok!
i tried this on a table with 4 colums:
amount year 2010
amount year 2011
% : amount year 2011/amount year 2010
i set column 2 and 3 to full accumulation, but what do i do now with the%?
it still calculates as if it wasn't accumulated!
Thanks! Such an easy answer