Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ThePeterK
Creator
Creator

Distinct Count of Customers on Last Day

Our qvd has one record per customer, per subscription. I'm trying to make a bar chart that represents the number of unique customers active at the end of each month/year (i.e. the max date in the group).

I can get a distinct count by month. I'm able to calculate the correct end date for each year via aggr(NODISTINCT max([Period Date]),[Fiscal Year]) , however that calculation is not working in the bar chart expression that drills down from fiscal year to period date. In the example, I want the value for Fiscal Year 2015-2016 to equal 43,167. Instead, it shows 56,543.

clipboard_image_2.png

Here's the expression I've been working with/on, but I could really use some help:

count({<[Period Date]={'=aggr(NODISTINCT max([Period Date]),[Fiscal Year])'}>}distinct [Customer ID])

93/93
Labels (2)
1 Reply
Channa
Specialist III
Specialist III


=Count({$<[Period Date]={"=MonthEnd(Today() ,0)"}>} distinct CustomerID)==end of current month

 

Channa