Skip to main content
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: 
PjK2
Contributor
Contributor

How to sum up dates

I am trying to sum up the days and I am struggling. 

My date format is M/D/YYYY

1/29/2022

1/31/2022

2/4/2022

2/4/2022

1/29/2022

How can I sum up the days?

 

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

HI

Then you can use

Count(Dates) -- it gives no. of occurrence. 

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan

Hi

Do u want to count the dates? 

If so, try like Count(Distinct Dates)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
PjK2
Contributor
Contributor
Author

Hi 

No, I don't want to count the dates because it gives me just 1 for each date. 

Wherever the days are the same:

1/4/2022

3/4/2022 

I want it to give me 2 instead of each date.

MayilVahanan

HI

Then you can use

Count(Dates) -- it gives no. of occurrence. 

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.