Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

Tags (1)
2 Replies

Re: How to count the number of dates?

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


talk is cheap, supply exceeds demand
MVP
MVP

Re: How to count the number of dates?

Hi,

Try to use DISTINCT in Count function.

=Count(DISTINCT DateFieldName)

Regards,

Jagan.

Community Browser