topic Re: Creating Quarter in QlikView

Creating Quarter

rathnam_qv — Wed, 09 Oct 2013 09:08:51 GMT

Hi all,

i hv the following number format from that i have to calculate Quartes..

how to do that can any one help me...

Thanks in advance

Smiley

Re: Creating Quarter

Anonymous — Wed, 09 Oct 2013 09:11:46 GMT

Are these no. Representing date?

If yes

Then first You can convert them in Date Format by using Date(Fieldname,'DD/MM/YYYY') and then make quarter using the month in it.

Re: Creating Quarter

Gysbert_Wassenaar — Wed, 09 Oct 2013 09:13:18 GMT

It looks like your ABC field contains numeric dates. That's good. ceil(month(ABC)/3) will then create the quarternumbers. It's best to create a Quarters field in the script. Below is an example (so don't copy it blindly into your script):

Load

ABC,

Month(ABC) as Month,

dual('Q' & ceil(month(ABC)/3), ceil(month(ABC)/3)) as Quarter

Year(ABC) as Year

From ...sourcedata...;

By using the dual function the Quarter field will have a numeric value (1 to 4) and a display value Q1 to Q4.

Re: Creating Quarter

vikasmahajan — Wed, 09 Oct 2013 09:13:39 GMT

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

take that date with tempdate and give above formula for Qtr

Vikas

Re: Creating Quarter

mdmukramali — Wed, 09 Oct 2013 09:26:15 GMT

Dear,

kindly find the attachment.

Thanks,

Mukram.

Re: Creating Quarter

CELAMBARASAN — Wed, 09 Oct 2013 09:35:09 GMT

Try with

'Q' & Ceil(Month(DateField) / 3) AS QuarterFieldName

Re: Creating Quarter

polisetti — Wed, 09 Oct 2013 09:35:48 GMT

convert them in Date Format by using Date(Fieldname,'DD/MM/YYYY')

And then

rowno() as Month,

'Q' & Ceil (rowno()/3) as Quarter;

Re: Creating Quarter

salto — Wed, 09 Oct 2013 09:42:58 GMT

Hi,

Dual('Q'&Num(Ceil(Num(Month(Date))/3)),

Num(Ceil(NUM(Month(Date))/3),00)) as [Quarter],

Year(Date)&Dual('Q'&Num(Ceil(Num(Month(Date))/3)),

Num(Ceil(NUM(Month(Date))/3),00)) as [Year Quarter] ;

Do work for me in all my documents.

Regards!