Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Help on calculating cumulative of distinct count of suppliers for rolling 12 month Period

Hi All,

I need to calculate the cumulative distinct count of suppliers over last 12 months. It should be from 2016 August to this year August month. Anyone have any idea on this?

Regards,

Smruti

1 Reply
MVP
MVP

Re: Help on calculating cumulative of distinct count of suppliers for rolling 12 month Period

Best way to do this would be to use The As-Of Table