topic Re: Re: Problem in Master Calendar in QlikView

Problem in Master Calendar

Fri, 08 Nov 2013 16:26:40 GMT

Hi Experts,

I am creating a Master Calendar where I am stuck on two Periods.

I have requirement that when a user selects option Current QTD vs Previous QTD, Data for change metrics compares

Current QTD and Previous QTD of same year as well as if current month is Nov and User has selected Current QTD vs Previous QTD then comparision is from Oct+Nov(Q4) and Jul+Aug(Q3) Not the full Quarter.

Similarly for STD.

It is working fine for Current & Previous Month and YTD but problem is in QTD and STD.

I am attaching my working sample QVW file with Sample Data. Kindly help.

Re: Problem in Master Calendar

Gysbert_Wassenaar — Fri, 08 Nov 2013 18:06:33 GMT

Try these:

InQuarter(Temp_Date, Today(), -0 )*-1 as PrevQTDFlag,

InQuarter(Temp_Date, Today(), -1 )*-1 as PrevQTDFlag,

YearToDate(Temp_Date, 0, Ceil(Month(Today())/6) * 6 - 5 )*-1 as CurSemesterFlag,

InQuarter(Temp_Date, Today(), -2 )*-1+InQuarter(Temp_Date, Today(), -3 )*-1 as PrevSemesterFlag

Re: Re: Problem in Master Calendar

Sun, 10 Nov 2013 15:21:38 GMT

Hi Wassenaar,

Thanks for the reply but it is not working. I am ataaching QVW file for ur refrence after incopoarting above script.

Regards,

Kumar

Re: Re: Re: Problem in Master Calendar

sibin_jacob — Tue, 12 Nov 2013 04:01:21 GMT

Hi Kumar,

Please find the attached document and let me know if you have any concerns/questions.

Thanks,

SIbin Jacob.C