counting for historical data using chart

[laujerry]

i hv a customer grade change table like this:

customer_id, grade, start_date, end_date, sumcount

1, C, 1/1/2013, 31/12/2013, 1

1, B, 1/1/2014, 31/12/2999, 1

2, B, 1/1/2013, 30/6/2013, 1

2, A, 1/7/2014, 31/12/2999, 1

how can i use a chart (straight/pivot table) to show

dimension: year/month/grade

expression: no of customer (of particular grade) at the period

(p.s. if a customer change more than 1 time in a month, i will consider the grade in his/her last change)

i think this table is not capable of making the chart

so how should i transform it to achieve the goal?

no idea at all, thanks!

[adiarnon · Accepted solution]

You should create all dates in the intervals using a while loop. See

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

ADI

[laujerry]

thank you adi... this do help!