How to count the number of dates? - Qlik Community

Report Inappropriate Content · ‎2015-06-12

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.

Gysbert_Wassenaar · ‎2015-06-12

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

talk is cheap, supply exceeds demand

jagan · ‎2015-06-12

Hi,

Try to use DISTINCT in Count function.

=Count(DISTINCT DateFieldName)

Regards,

Jagan.