topic Re: How to create Quaters for fiscal year? in QlikView

How to create Quaters for fiscal year?

arunqlik2view — Fri, 06 Jul 2018 02:41:21 GMT

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

Re: How to create Quaters for fiscal year?

Anil_Babu_Samineni — Fri, 06 Jul 2018 03:54:07 GMT

You can change this to

SET FirstMonthOfYear=4;

Re: How to create Quaters for fiscal year?

vikasmahajan — Fri, 06 Jul 2018 06:54:13 GMT

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,

Re: How to create Quaters for fiscal year?

arunqlik2view — Fri, 06 Jul 2018 07:47:02 GMT

Thanks Vikas this worked perfect for me.

Re: How to create Quaters for fiscal year?

arunqlik2view — Fri, 06 Jul 2018 07:48:34 GMT

Thanks Vikas this worked perfect for me.

Re: How to create Quaters for fiscal year?

arunqlik2view — Fri, 06 Jul 2018 07:50:45 GMT

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;'

Re: How to create Quaters for fiscal year?

vikasmahajan — Fri, 06 Jul 2018 09:48:13 GMT

Can you please mark as correct answer !!

Vikas