topic Re: Help with Set Analysis using Today() in QlikView

Help with Set Analysis using Today()

Thu, 08 May 2014 10:31:31 GMT

Can anyone please tell me what I'm doing wrong here

All I want to do is create a bar chart for today's open calls by category.

This works fine:

Count({1<ARRIVAL_DATE={'08/05/2014'},AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Then I want to add Today() so that if the report hasn't been refreshed nothing shows, but I can't seem to get the syntax right:

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'YYYY-MM-DD'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Many thanks

Paul

Re: Help with Set Analysis using Today()

tresB — Thu, 08 May 2014 10:33:32 GMT

try:

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Be careful of the date format.

Re: Help with Set Analysis using Today()

Thu, 08 May 2014 10:36:58 GMT

Sure I'd tried that many times, and that I'd just introduced it by error when cutting and pasting from a previous post, but it now works. Many thanks

Re: Help with Set Analysis using Today()

its_anandrjs — Thu, 08 May 2014 10:37:08 GMT

Try with

You date format is not matched it is 'DD/MM/YYYY'

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Re: Help with Set Analysis using Today()

jagan — Thu, 08 May 2014 10:38:44 GMT

Hi Paul,

Date format is the issue in Expression try this expression, you are formatting Today() to this 'YYYY-MM-DD' format but your date is in 'DD/MM/YYYY' format.

=Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

Regards,

jagan.