Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Expression COUNT from MinDate to Selected Date

Hi guys,

I'm trying to create an expression in my report in order to show the information from first day until selected date.

I have the raw data below:

Sign Up DateCustomer
1/1/2015CustomerA
1/1/2015CustomerB
1/1/2016CustomerC
1/1/2016CustomerD
1/1/2017CustomerE
1/1/2018CustomerF

 

I have a "Year" selection, if I never select anything, the result should add up accumulate as below:

Year# Customer
20152
20164
20175
20186

 

If I selected 2018, my result should show as below (It will show the number from MinDate until Selected Date/Year):

Year# Customer
20186

 

Currently I'm using below expression but it's not working. When I selected 2018, it show "1" instead of "6"

IF(GetSelectedCount(Year)=0,
COUNT({<Date = {"<=$(=Today())"}>} DISTINCT Customer),
COUNT({<Date = {"<=$(=Date(Max(Date)))">} DISTINCT Customer))

Thank you in advance ! 

Labels (3)
1 Solution

Accepted Solutions
Highlighted

Try this

RangeSum(Above(Count(DISTINCT {<Year>} Customer), 0, RowNo())) * Avg(1)

View solution in original post

2 Replies
Highlighted

Try this

RangeSum(Above(Count(DISTINCT {<Year>} Customer), 0, RowNo())) * Avg(1)

View solution in original post

Highlighted
Contributor III
Contributor III

Hi Sunny, Thanks for your help! Your formula is working! but I think because of my data issue, I'm not getting the expected result. I will try to solve from data end. Thanks again for your help!