Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
christinehuband
Contributor III
Contributor III

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

christinehuband
Contributor III
Contributor III

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]))

View solution in original post

christinehuband
Contributor III
Contributor III

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

Never would have found this one on my own.