Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Count by First Date

If I am counting presentations given per week.  But my table has some presentations with two date values in error, how do I get the count to only show in one week. Preferably the earliest date?  Below is a sample table.  SOme of the counts each week are overstated because my data might have two week dates listed for a presentation.  Thanks!

count

({$<PresentationType = {'*Life*','*Senior*'}-{'*Paid Up*','*Select*'}, HouseholdMember = {'Primary'}>} Distinct PresentationID)

Week   Presentation Given

07/05/2012     1,898

07/12/2012     1,959

07/19/2012     2,063

07/26/2012     1,929

08/02/2012     2,033

08/09/2012     1,943

08/16/2012     1,933

08/23/2012     2,040

08/30/2012     1,938

09/06/2012     1,712

09/13/2012     1,851

09/20/2012     1,968

09/27/2012     2,020

10/04/2012     1,923

10/11/2012     1,773

10/18/2012     1,928

Presentation
  Given
07/05/20121,898
07/12/20121,959
07/19/20122,063
07/26/20121,929
08/02/20122,033
08/09/20121,943
08/16/20121,933
08/23/20122,040
08/30/20121,938
09/06/20121,712
09/13/20121,851
09/20/20121,968
09/27/20122,020
10/04/20121,923
10/11/20121,773
10/18/20121,928