Cumulative Distinct Count for Pivot table charts only

Sat, 16 Apr 2011 00:53:25 GMT

Hello,

I'm trying to develop a solution ( which should be a pivot table) where I want to plot Report date month on rows and Action date month on columns. Measure is distinct user count. Now this user count should also be cumulative.

What that means is for action date month March and report date month January, I should get distinct count of users who have reported problem in January and Action is taken in January or Febrauary or March ( distinct count over all 3 months). The final chart should somewhat look like this

Action date	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Reported date
Jan	100	200	90	150	45	353	3434	333	55	5342	53	4512
Feb		21	2	43	35	54	54	65	65	64	42	345
Mar			53	5	344	45	55	22	42	54	4	23
Apr				34	32	43	32	43	343	545	43	355
May					43	12	23	4343	676	887	4343	63
Jun						41	22	43	8	98	43	6643
Jul							44	123	9	45	123	36
Aug								42	7676	32	858	45
Sep									4334	32	56	46
Oct										54	668	346
Nov											545	46
Dec												54

Let me know if any one has idea of how to implement this solution.

Thanks for any help in advance.

Amey

topic Cumulative Distinct Count for Pivot table charts only in QlikView

Cumulative Distinct Count for Pivot table charts only