Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
senior_freshmen
Contributor III
Contributor III

Show Count(ID) per Year

Hello Guys, 

 

I try to implement a Count of ID cummulated per year. 
DATA: 

ID Timestamp
1 14:00:00 01.01.2019
2 14:00:00 02.01.2019
3 14:00:00 01.01.2021
4 14:00:00 01.01.2022

 

Now I Like to display this Values based on year, so for 2019 the Count is 2 and so forth and so on. 

 

Any help is highly appreciated. 

With best regards

Labels (5)
1 Solution

Accepted Solutions
Bunim
Contributor III
Contributor III

add sum. 

like this - 

sum(aggr(count(ID),year(Timestamp)))

 

View solution in original post

5 Replies
Bunim
Contributor III
Contributor III

aggr(count(ID),year(Timestamp))

senior_freshmen
Contributor III
Contributor III
Author

Do I have to insert it in the Expression tab of the Diagram? It does not show any Entries

senior_freshmen_0-1645531710070.png

I am using a Master Calendar by the wy, where I am setting up the Data via the TimeStamp Field. 

senior_freshmen_1-1645532053958.png

Looks like the aggr() Function does not resolve the Result correct

Bunim
Contributor III
Contributor III

Click on the component and his Expression will open. not on the Sheet.

senior_freshmen
Contributor III
Contributor III
Author

senior_freshmen_1-1645533238673.png

senior_freshmen_2-1645533261453.png

 

Bunim
Contributor III
Contributor III

add sum. 

like this - 

sum(aggr(count(ID),year(Timestamp)))