Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arsalanam
Creator
Creator

Cumulative Count DISTINCT over Months - Remove Duplicates from previous Month

Have a scenarios where I need to do the Cumulative Count on SalesPersons for each Month, the requirement is if the person's ID is already counted in any of the previous months it should not be Counted again e.g.:

Month     ID   

Jan         ID01

Jan         ID03

Feb         ID02

Feb         ID01

Mar         ID02

Mar         ID05

Apr         ID03

Apr         ID09

Apr         ID01

The result should be:
Month     ID_Count

Jan         2

Feb        3

Mar        4

Apr        5

Need to show it in Line chart, can't use Qlik's built in "Accumulate" option as it just adds values from previous month.

Any suggestions ?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I think the approach using an AsOf table I've suggested here

Accumulated Distinct Count

should also work for you.

View solution in original post

3 Replies
swuehl
MVP
MVP

I think the approach using an AsOf table I've suggested here

Accumulated Distinct Count

should also work for you.

arsalanam
Creator
Creator
Author

swuehl This works in most cases but if Jan and Mar are selected from Month filter, this shows cumulative sum of Jan, Feb and Mar against Mar.

swuehl
MVP
MVP

In which month field(s) are you doing the selection?