Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Sum today() problems

Hi,

I'm trying to count the today orders , but it doesn't work!!!

=NUM(Count(DISTINCT{<[SALESID]={'PV0***'},DATEFINANCIAL={'>=$(=Today())'},ESTADO_PEDIDO={'Facturado'}>} SALESID),'#.###,')

Thank's

Eduard

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand