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: 
Anonymous
Not applicable

Count in Total Row of Date Column

Silly question time I suspect.

I have a column of dates that I'd like to get a count of in the total row (only dates and null in the column).

Unfortunately the total row is formatted as a date as well. How can I get it tell me how many rows have a date in them?

Thank you!

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

IF(Dimensionality()=0,COUNT([Date Closed]),Date([Date Closed]))

or

IF(Dimensionality()=0,COUNT(DISTINCT [Date Closed]),Date([Date Closed]))

View solution in original post

4 Replies
hector_munoz
Specialist
Specialist

Hi Christine,

Try to put the following option in the expression desired:

09-06-2017 15-30-47.png

Regards,

H

Anonymous
Not applicable
Author

Tried that one. The problem is that the column is Date formatted.

MK_QSL
MVP
MVP

IF(Dimensionality()=0,COUNT([Date Closed]),Date([Date Closed]))

or

IF(Dimensionality()=0,COUNT(DISTINCT [Date Closed]),Date([Date Closed]))

Anonymous
Not applicable
Author

Perfect, thank you! The top one did the trick.

Never would have found this one on my own.