Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Cumulative Distinct Count for Pivot table charts only

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 dateJanFebMarAprMayJunJulAugSepOctNovDec
Reported date
Jan10020090150453533434333555342534512
Feb2124335545465656442345
Mar5353444555224254423
Apr343243324334354543355
May4312234343676887434363
Jun412243898436643
Jul4412394512336
Aug4276763285845
Sep4334325646
Oct54668346
Nov54546
Dec54


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

Thanks for any help in advance.

Amey