How to create Quaters for fiscal year? - Qlik Community

arunqlik2view · ‎2018-07-05

Hi all ,

I want to create quaters Q1, Q2 ,Q3 and Q4 to represent Fiscal Year In qlikview.

If I choose Q1 , Qlikview must enable only Apr, May and June .

Thanks in Advance

Arun

Anil_Babu_Samineni · ‎2018-07-05

You can change this to

SET FirstMonthOfYear=4;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vikasmahajan · ‎2018-07-06

Add this line in master calendar

'Q' & alt(if(Month(TempDate)<4,4),if(Month(TempDate)<7,1),if(Month(TempDate)<10,2),3) AS Quarter,

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

arunqlik2view · ‎2018-07-06

Thanks Vikas this worked perfect for me.

arunqlik2view · ‎2018-07-06

Thanks Vikas this worked perfect for me.

arunqlik2view · ‎2018-07-06

Thanks Anil for the reply ,

First I tried to change the value to 4 as per post , it did not work for soem reason, Then I chnaged the order of teh months as given below and it worked for me . But I think go Vikas' syntax.

SET MonthNames='Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan;Feb;Mar;'

SET LongMonthNames='April;May;June;July;August;September;October;November;December;January;February;March;'

vikasmahajan · ‎2018-07-06

Can you please mark as correct answer !!

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.