topic how to count dates? in QlikView https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283635#M105432 <HTML><HEAD></HEAD><BODY><P>that could be. does this work?</P><P></P><P></P><P>Count(Distinct date(TPE_FEC))</P></BODY></HTML> Tue, 06 Dec 2011 19:32:30 GMT 2011-12-06T19:32:30Z how to count dates? https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283632#M105429 <HTML><HEAD></HEAD><BODY><P> Thanks in advance to answer this simple question.</P><P>I have a list&nbsp; of duties and dates. A worker can do several jobs in the same date. I need to count how many days has he/she been working, taking in considetarion that 3 jobs in 05/12/2011 is only 1.</P><P>How to do count 1 day if in the list I have 3 times the 05/12/2011??</P><P>Thanks in advance</P></BODY></HTML> Tue, 06 Dec 2011 19:12:29 GMT https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283632#M105429 2011-12-06T19:12:29Z how to count dates? https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283633#M105430 <HTML><HEAD></HEAD><BODY><P>try Count(Distinct date)</P></BODY></HTML> Tue, 06 Dec 2011 19:17:47 GMT https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283633#M105430 2011-12-06T19:17:47Z how to count dates? https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283634#M105431 <HTML><HEAD></HEAD><BODY><P>Thanks but it doesn't work.&nbsp; I have put&nbsp;&nbsp;&nbsp; COUNT( [DISTINCT] TPE_FEC) without&nbsp; "," or something else but it doesn't work.&nbsp; The format of the date is YYYY-MM-DD&nbsp; HH:MM:SS . Could be this&nbsp; the problem??</P></BODY></HTML> Tue, 06 Dec 2011 19:31:13 GMT https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283634#M105431 2011-12-06T19:31:13Z how to count dates? https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283635#M105432 <HTML><HEAD></HEAD><BODY><P>that could be. does this work?</P><P></P><P></P><P>Count(Distinct date(TPE_FEC))</P></BODY></HTML> Tue, 06 Dec 2011 19:32:30 GMT https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283635#M105432 2011-12-06T19:32:30Z how to count dates? https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283636#M105433 <HTML><HEAD></HEAD><BODY><P> IT WORKS ¡¡¡&nbsp;&nbsp; thanks very much.</P></BODY></HTML> Tue, 06 Dec 2011 19:45:05 GMT https://community.qlik.com/t5/QlikView/how-to-count-dates/m-p/283636#M105433 2011-12-06T19:45:05Z