topic Re: Hi team in QlikView

Hi team

Kohli — Wed, 25 Nov 2020 16:16:04 GMT

I have created Quarter for a year. Q1-JAN,FEB, MAR Q2-APR MAY JUN Q3-JUL AUG SEP Q4-OCT NOV DEC.

BUT I WANT Q1 as APR, MAY, JUN

pls help me how can i change it.

Re: Hi team

Clever_Anjos — Tue, 24 Oct 2017 10:32:35 GMT

Could you show us how you´ve created your Quarter?

Re: Hi team

techvarun — Tue, 24 Oct 2017 10:33:16 GMT

Where you created these mapping in a File or in an INLINE load.

A sample will help here.

Re: Hi team

sergio0592 — Tue, 24 Oct 2017 10:38:34 GMT

Try with :

quartername(Date_field, 0, 4)

Re: Hi team

its_anandrjs — Tue, 24 Oct 2017 10:39:39 GMT

Add new mapping table in your data model.

Ex:-

QrtMap:

Mapping LOAD

[

Month,Quarter

APR,Q1

MAY,Q1

JUN,Q1

JUL,Q2

AUG,Q2

SEP,Q2

OCT,Q3

NOV,Q3

DEC,Q3

JAN,Q4

FEV,Q4

MAR,Q4

];

LOAD

ApplyMap('QrtMap',MonthField,Null()) as NewWuarter

from Location;

Re: Hi team

prma7799 — Tue, 24 Oct 2017 10:42:47 GMT

Try like this at backend

'Q' & alt(if(Month([Date])<4,4),if(Month([Date])<7,1),if(Month([Date])<10,2),3) as Quarter

Re: Hi team

Kohli — Tue, 24 Oct 2017 10:48:43 GMT

I HAVE create two varibles V1 as start date from 1-1-2001' v2 end date 31-12-2010'

using dual (ceil(month/3)) like that way i have creatd, but my business year started from Apr_Mar not jan_Dec

Re: Hi team

Clever_Anjos — Tue, 24 Oct 2017 11:00:29 GMT

could you post your exact code?

I´m gonna change it for you

Re: Hi team

vikasdesai — Tue, 24 Oct 2017 11:01:22 GMT

Hello

Put Following Script In Your Backend-

Temp:

Load

min(Date) as minDate,

max(Date) as maxDate

Resident MainData;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

DROP Table Temp;

Master Calender:

Load *,

dual('Q'&ceil([Fiscal Month Num]/3),ceil([Fiscal Month Num]/3)) as FiscalQuarter;

Load

if (month(TempDate)<=3,month(TempDate)+(12-3), month(TempDate)-3) AS [Fiscal Month Num];

LOAD

$(varMinDate) + Iterno()-1 As Num,

Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

Regards

Vikas

Re: Hi team

Clever_Anjos — Tue, 24 Oct 2017 13:07:44 GMT

Please try with

dual('Q'&ceil(Addmonths([Fiscal Month Num],3)/3),ceil(Addmonths([Fiscal Month Num],3)/3)) as FiscalQuarter;

Re: Hi team

florentina_doga — Tue, 24 Oct 2017 13:48:16 GMT

in qlikview 12 is system setting

Set FirstMonthOfYear=4;