How to count(distinct date) like this

[porrmatnoisa]

expression: count(total distinct date)

I need to be on a excel file

I have no idea. Please Help me.

Thank you

[Antoine04]

If you have a calendar in your datamodel, you can use "total" to count all the day by month.

Ex : Count(Total Date)

Let me know if you need more help on it. If yes, please share the .qvf

[porrmatnoisa]

This is my data model

when I use a total expression "count(total distinct date)" it shows a total of pivot table like this

Qlik sense does not show each YearMonth and each Year

[Antoine04 · Accepted solution]

Then try with count(total <MonthName> distinct date) : counting all the dates by month.

Is it working ?

[porrmatnoisa]

I get it. Think you so much.