topic Re: Dates. in QlikView

Dates.

Wed, 30 Jul 2014 08:17:04 GMT

Hi All,

I have the following script that sets up my variables:

Let vCurrYear=year(today());

Let vCurrMonth=month(today());

Let vCurrDay= (I want this variable to be set to the previous day in date format)

Let vPrevYear=Year(AddYears(today(), -1));

Let vPrevMonth=Month(AddMonths(today(),-1));

Let vPrevDay=(I want this variable to be set to the vCurrentDay-1 day in date format)

Please help,

crusader_ — Wed, 30 Jul 2014 08:19:48 GMT

Try this

Let vCurrDay= date(today()-1)

and

Let vPrevDay = date(today()-2)

Hope this helps.

Andrei

Wed, 30 Jul 2014 08:23:11 GMT

ok so thats sets up the variables great, but the my set analysis doesn't

Sum({1<call_date = {$(vCurrDay)}>} calls_offered)

crusader_ — Wed, 30 Jul 2014 08:48:42 GMT

Hi,

Please check variable value and your call_date in text object.

And ensure that call_date has a date format.

HTH

Andrei