topic get quarter start month in QlikView

get quarter start month

Fri, 16 Mar 2012 08:41:40 GMT

Hi all,

how can i get the first month of a quarter + it's year from the following information:

From 2011-Q1 i want to get 201101

from 2011-Q2 i want to get 201104

etc

Thanks a lot!

get quarter start month

jvitantonio — Fri, 16 Mar 2012 08:52:04 GMT

so, I don't think this is a DATE field, so you'll need to do it with code. IF your field is a DATE field, you can you the function QuarterStart. In your example do:

Let's suppose the field that contains the value "2011-Q1" is called DATE

left(DATE,4) (this will give you 2011)

Then you can concatenate with '&' symbol.

=left(DATE,4)&IF(RIGHT(DATE,2)='Q1',01, IF(RIGHT(DATE,2)='Q2',04,IF(RIGHT(DATE,2)='Q3',07,10)))

Re: get quarter start month

kaushiknsolanki — Fri, 16 Mar 2012 08:53:12 GMT

Hi,

Have a look at the application.

Regards,

Kaushik Solanki

get quarter start month

christophebrault — Fri, 16 Mar 2012 08:56:38 GMT

Where do you want to do this ?

In the script or in expression ?

I think there is many way to get your result, there is a simple i think :

If you have Quarters as a dimension, an expression like :

min(MonthName)

will give you good results.

Can you give us more details or exemple of what you want to do ?

Re: get quarter start month

CELAMBARASAN — Fri, 16 Mar 2012 09:11:41 GMT

Hi,

Check with this

Left('2011-Q1',4)&Num(((Right('2011-Q1',1)-1)*3)+1,'00')

If you want to make it as date then use like below

Date#(Left('2011-Q1',4)&Num(((Right('2011-Q1',1)-1)*3)+1,'00'),'YYYYMM')

Celambarasan