Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jerfwork
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
sunny_talwar

Try this

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

View solution in original post

2 Replies
sunny_talwar

Try this

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

View solution in original post

jerfwork
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!