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

How to count the number of dates?

Hi,

I have a dataset with 6 dates where the dates are crosstabled. When I do a count on datefield, count(datefield), I get a count over 100. Is there any way to only get a count of 6, for 6 days?

Thanks.

2 Replies
Gysbert_Wassenaar

Perhaps count(distinct datefield). If not you'll have to give more information about your dataset.


talk is cheap, supply exceeds demand
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try to use DISTINCT in Count function.

=Count(DISTINCT DateFieldName)

Regards,

Jagan.