topic Re: Calendar in QlikView

Calendar

Wed, 07 Jan 2015 09:12:44 GMT

Hi All

could you please explain the meaning of the below query and how this can be used to generate Current Year vs Last Year,Current Month vs Previous Month , Current month in this year and current month in last year, YTD,MTD,QTD

date(DATE) as DATE,

YEAR(ADDMONTHS(DATE,-3)) AS YEAR,

TEXT(MONTH(DATE)) AS MONTHLINK,

Week(DATE) as WEEK,

monthname(DATE)AS MONTHNAME,

Day(DATE) as DAY

Thank you in Advance

Jayanthan

Re: Calendar

Wed, 07 Jan 2015 09:16:10 GMT

For a good calendar I would use the following for Calendar:

The Fastest Dynamic Calendar Script (Ever)

and with regard to comparisons I would read the following:

QlikView App: Set Analysis - Prior Period Comparison

Re: Calendar

its_anandrjs — Wed, 07 Jan 2015 09:25:31 GMT

Hi,

Better way you try this

MasterCalendar:

Load

TempDate,

TempDate AS DateField,

Week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month,

'Q'&Ceil(Month(TempDate)/3) as Qtr,

Day(TempDate) As Day,

YeartoDate(TempDate)*-1 as CurYTDFlag,

YeartoDate(TempDate,-1)*-1 as LastYTDFlag

Resident TempCalendar

Order By TempDate ASC;

Regards

Anand

Re: Calendar

richard_pearce6 — Wed, 07 Jan 2015 09:33:16 GMT

Hi,

You could also try an as of calendar. Here's a working example http://community.qlik.com/docs/DOC-6593

Richard