topic Re: Quater creation (adding the required months to the Q1,Q2,Q3,Q4). in QlikView

Quater creation (adding the required months to the Q1,Q2,Q3,Q4).

Sun, 23 Feb 2014 16:59:53 GMT

Hi Floks,

When we create the calender , (Jan,Feb,Mar will fall under Q1, Apr,May,June will fall under Q2, July,Aug,Sep will fall under Q3, Oct,Nov,Dec will fall under Q4).

But i would like to display the (Nov,Dec,Jan into the Q1, Feb,Mar,Apr into Q2.... respectively )

Can Some one Help on this.

Regards,

Rajesh.

Re: Quater creation (adding the required months to the Q1,Q2,Q3,Q4).

MK_QSL — Sun, 23 Feb 2014 17:22:45 GMT

Create an Inline Table as below..

Load * Inline

[

Month, Quarter

Nov, Q1

Dec, Q1

Jan, Q1

Feb, Q2

Mar, Q2

Apr, Q2

May, Q3

Jun Q3

Jul, Q3

Aug, Q4

Sep, Q4

Oct, Q4

];

Re: Quater creation (adding the required months to the Q1,Q2,Q3,Q4).

maxgro — Sun, 23 Feb 2014 17:27:24 GMT

check this if you want to shift quarter

Issue with Quarter!

Re: Quater creation (adding the required months to the Q1,Q2,Q3,Q4).

aveeeeeee7en — Sun, 23 Feb 2014 17:37:46 GMT

Hi Rajesh

See the Attached.

Its Simple and easy.

Use this Code in your script and do replace the Date with your Date:

'Q'&Ceil(Num(Month(AddMonths(Date,-10)))/3)

as [Fiscal Quarter]

Regards

Aviral Nag

Re: Quater creation (adding the required months to the Q1,Q2,Q3,Q4).

Mon, 24 Feb 2014 08:54:49 GMT

Hi Nag Tanks a lot