topic Re: Query for Calculate Quarter values in DB2 in QlikView

Query for Calculate Quarter values in DB2

rathnam_qv — Sat, 27 Jul 2013 06:54:49 GMT

Hi all,

Now i am doing Validation..

i have month id's like (201201,201202,201203........201212)Jan to Dec..

i am trying to calculate Quarter values..but it's not giving Cumulative values..it's giving value for each month...

can any one help me to get that values for each quarter...

Thanks!!!

Smiley

kaushiknsolanki — Sat, 27 Jul 2013 07:10:37 GMT

HI,

Create a quarter in script.

Something like this.

Ceil(num(Month(Makedate(right(Field,4),Left(Field,02))))/3) as Quarter.

Here Field is the column name which has text inthe form of YYYYMM.

One you get the correct Quarters then use the Quarter field in your chart/Groups to get Values according to Quarter.

Regards,

Kaushik Solanki

rathnam_qv — Sat, 27 Jul 2013 13:34:30 GMT

Hi Kaushik,

Thanks for ur replay

But i need to calculate that in Sql Server

so, i need SQL Query