topic Re: counting for historical data using chart in QlikView

counting for historical data using chart

laujerry — Sun, 13 Jul 2014 02:13:51 GMT

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 — Sun, 13 Jul 2014 04:52:40 GMT

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

ADI

laujerry — Sun, 13 Jul 2014 08:17:37 GMT

thank you adi... this do help!