ISSUE IN Quarterly Comparison

[#1]

Please help me in this

I have attached the images such as;

• my code
• used dimension and expressions
• out put which I got

Problem is my financial year starts in April but if you see my out put there is no data for Qtr-1 2014 which have mode to Qtr2- 2014 and Qtr3-2014 which should empty can you please help me to clear the issue. I think there might be a problem in CALENDAR codding

CODE

DIMENSION

EXPRESSIONS

OUTPUT

[senpradip007]

Could you please upload a sample qvw?

[Anonymous]

I would refer to the below link for knowledge on implementing a Fiscal Calendar

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

If you want a short cut to deploy a fast and reliable Fiscal Master Calender,  Google "qlikview components" and d/l it and read the instructions on how to include it in your script and call the Master Calendar.  It's worth the research.

[VishalWaghole]

Hi Mafaz,

Your Quarter expression should be like,

'Qtr' &''& Ceil(Num(Month(Date))/3) &'-'& Year(Date) as QUARTERLY

Hope this will work for you.

-- Regards,

Vishal Waghole

[VishalWaghole]

Hi Mafaz,

Please check with this link, i guess its same that you have uploaded previously..

community.qlik.com/thread/124892

-- Regards,

Vishal Waghole

[#6]

Thank You!

that's helped me but according to my Org months starts from April if you see my attachment you can find that I got the method but its working if the Qtr starts from Jan not April. please help me

[VishalWaghole]

Hi,

Please try using below expression,

if(num(Month(Date)) >= 4 and num(Month(Date)) <= 6,'Q1',

     if(num(Month(Date)) >= 7 and num(Month(Date)) <= 9,'Q2',

     if(num(Month(Date)) >= 10 and num(Month(Date)) <= 12,'Q3','Q4'))) &'-'& Year(Date) as QuarterYear

Hope this will solve your problem.

-- Regards,

Vishal Waghole

[#8 · Accepted solution]

Hi guys I guess I found the answer find it below

'Qrt'&' '& Ceil(Num(MONTH(AddMonths(QuarterStart(DATE),-1)))/3)&'-'&Year(AddMonths(QuarterStart(DATE),-1)) as QUARTERLY,