topic Re: Sum today() problems in QlikView

Sum today() problems

ecabanas — Tue, 30 Jul 2013 15:00:58 GMT

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

Re: Sum today() problems

alexandros17 — Tue, 30 Jul 2013 15:07:20 GMT

The syntax is correct, I think the problem is linked to date format;

try to input an exact date instead of today and see if it works for example 25/03/2013 ....

Work on date format to solve the problem

Let me know

Re: Sum today() problems

ecabanas — Wed, 31 Jul 2013 10:29:03 GMT

Hi Alex,

I still have a problem:

when I do this it works: =NUM(Count(DISTINCT{<[SALESID]={'PV0***'},CREATEDDATEID_={'41485'},CalendarMonthName=,CalendarYear=,ESTADO_PEDIDO=>} SALESID),'#.###,')

But if I Use the variable VToday that is a result of =floor(today()) equal: 41486 does not work

=NUM(Count(DISTINCT{<[SALESID]={'PV0***'},CREATEDDATETIME={'=$(VToday)'},CalendarMonthName=,CalendarYear=,ESTADO_PEDIDO=>} SALESID),'#.###,')

Thank you very much!!!

Re: Sum today() problems

alexandros17 — Wed, 31 Jul 2013 12:14:18 GMT

use Date(floor(today())

....