Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me in this
I have attached the images such as;
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
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,
Could you please upload a sample qvw?
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.
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
Hi Mafaz,
Please check with this link, i guess its same that you have uploaded previously..
community.qlik.com/thread/124892
-- Regards,
Vishal Waghole
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
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
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,