topic Sum today() problems in QlikView https://community.qlik.com/t5/QlikView/Sum-today-problems/m-p/540272#M201904 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to count the today orders , but it doesn't work!!!</P><P></P><P></P><P>=NUM(Count(DISTINCT{&lt;[SALESID]={'PV0***'},DATEFINANCIAL={'&gt;=$(=Today())'},ESTADO_PEDIDO={'Facturado'}&gt;} SALESID),'#.###,')</P><P></P><P>Thank's</P><P></P><P>Eduard</P></BODY></HTML> Tue, 30 Jul 2013 14:47:55 GMT ecabanas 2013-07-30T14:47:55Z Sum today() problems https://community.qlik.com/t5/QlikView/Sum-today-problems/m-p/540272#M201904 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to count the today orders , but it doesn't work!!!</P><P></P><P></P><P>=NUM(Count(DISTINCT{&lt;[SALESID]={'PV0***'},DATEFINANCIAL={'&gt;=$(=Today())'},ESTADO_PEDIDO={'Facturado'}&gt;} SALESID),'#.###,')</P><P></P><P>Thank's</P><P></P><P>Eduard</P></BODY></HTML> Tue, 30 Jul 2013 14:47:55 GMT https://community.qlik.com/t5/QlikView/Sum-today-problems/m-p/540272#M201904 ecabanas 2013-07-30T14:47:55Z Re: Sum today() problems https://community.qlik.com/t5/QlikView/Sum-today-problems/m-p/540273#M201905 <HTML><HEAD></HEAD><BODY><P>The date format of $(=Today()) is probably not the same as the date format of DATEFINANCIAL. Make sure that DATEFINANCIAL is in fact a date field and not a string. And use the date() function if necessary to format the result of today() to the correct date format. For example $(=date(Today(),'DD/MM/YYYY')) if the date format of DATEFINANCIAL is DD/MM/YYYY</P></BODY></HTML> Tue, 30 Jul 2013 17:15:21 GMT https://community.qlik.com/t5/QlikView/Sum-today-problems/m-p/540273#M201905 Gysbert_Wassenaar 2013-07-30T17:15:21Z