topic Set Analysis with today() in QlikView

Set Analysis with today()

Wed, 04 Feb 2015 02:34:00 GMT

Hello all,

I am trying to return the widgets_purchsed for yesterday, but am getting errors. Can someone point me in the right direction?

=Count( {1<SESSION_START_TIME = {$(=Date(Today()-1, 'MM/DD/YYYY'))}>} widgets_purchsed )

Re: Set Analysis with today()

PrashantSangle — Wed, 04 Feb 2015 03:57:49 GMT

Hi,

Try with ""

=Count({<SESSION_START_TIME = {"$(=Date(Today()-1, 'MM/DD/YYYY'))"}>} widgets_purchsed )

Check your Session_start_Time format.

Regards

Re: Set Analysis with today()

jonathandienst — Wed, 04 Feb 2015 05:19:37 GMT

Does SESSION_START_TIME contain a time portion? If so, it will (almost) never be equal to Today(). The best solution is to split the time portion out from the date to create a proper date field during the load:

LOAD

...

Date(Floor(SESSION_START_TIME)), 'MM/DD/YYYY') As SESSION_START_DATE,

Time(Frac(SESSION_START_TIME)) As SESSION_START_TIME, // if you need the time portion

...

Now use SESSION_START_DATE in your set expression.

HTH

Jonathan

Re: Set Analysis with today()

Wed, 04 Feb 2015 16:19:28 GMT

Thanks!