Discussion Board for collaboration related to QlikView App Development.
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?
IF(Dimensionality()=0,COUNT([Date Closed]),Date([Date Closed]))
IF(Dimensionality()=0,COUNT(DISTINCT [Date Closed]),Date([Date Closed]))
View solution in original post
Try to put the following option in the expression desired:
Tried that one. The problem is that the column is Date formatted.
Perfect, thank you! The top one did the trick.
Never would have found this one on my own.