topic Re: Quarter format for Q1- 2011-12 in QlikView

Quarter format for Q1- 2011-12

Sat, 19 May 2012 02:57:58 GMT

Hi,

I need a quarter function format like "Q1 2011-12 " like this i need.

Help needed.

Regards,

Madhukumara

Anonymous — Sat, 19 May 2012 03:12:30 GMT

dateuse (exp for quarter) &'-'& year(date )&'-'& day(date)

jagannalla — Sat, 19 May 2012 05:31:42 GMT

Hello,

try this

'Q' & Ceil(Month(DateField)/3) & '-' & Year(DateField)& '-' & Day(DateField) AS CalendarQuarterAndYear

Hope it helps you.

Cheers!

kaushalview — Sat, 19 May 2012 06:44:20 GMT

Try this expression.

='Q'&ceil(month('2012-02-12')/3)&'-'&Yearname('2012-02-12',0,4)

='Q'&ceil(month('2012-02-12')/3)&'-'&Year('2012-02-12')&'-'&Day('2012-02-12')

Regards

Kaushal Mehta

Sat, 19 May 2012 10:13:46 GMT

need quarter format like Q1-2011-12 (Q1-yyyy-yy)

Q1-2012-13(Q1-yyyy-yy)

rajni_batra — Sat, 19 May 2012 10:31:57 GMT

Sat, 19 May 2012 10:52:42 GMT

for ur expression i am getting Q1-2011...

i need as Q1-2011-2012, Q2-2012-2013 (Q1-yyyy-yyyy)

jagannalla — Sat, 19 May 2012 12:56:31 GMT

Hello,

Try this code i think your looking for this solution only.

LOAD 'Q' & Ceil(Month(DateField)/3) & '-' & Year(DateField)& '-' & Year(YearEnd(DateField,1)) AS QCYrNyr

Hope it helps you.

Cheers !

Mon, 21 May 2012 10:25:06 GMT

Thanks Jagan