topic Re: How to create a Quarter Selection? in QlikView

How to create a Quarter Selection?

jim_chan — Fri, 25 Mar 2016 06:53:19 GMT

Hi guys,

Normal standard, when i create a quarter selection it, goes Q1-Q4.

thats what i want. but, due to diff financial year. i need to have a Q1 (Jul-Sep), Q2(Oct-Dec), Q3(Jan-Mar), Q4(Apr-Jun).

How can i do that???

Rite now. without doing anything. i got my quarter arrangement as such Q3,q4,q2,q1

Rgds,

Jim

Kushal_Chawda — Fri, 25 Mar 2016 06:54:53 GMT

see this

In your case SET vFiscalYearStartMonth = 7;

jim_chan — Fri, 25 Mar 2016 06:57:19 GMT

i got this.. but is this the only solution?

Gysbert_Wassenaar — Fri, 25 Mar 2016 07:04:55 GMT

No, there are hundreds of ways to do this. Here's another: 'Q' & Ceil(Month(MonthStart(MyDate,-6)) /3) as Quarter.

jim_chan — Fri, 25 Mar 2016 07:05:58 GMT

thanks Gysbert, i will try it out.

Kushal_Chawda — Fri, 25 Mar 2016 07:16:29 GMT

No, there are many ways. see this simple

if(match(month(Date),'Jul','Aug','Sep'),'Q1',

if(match(month(Date),'Oct','Nov','Dec'),'Q2',

if(match(month(Date),'Jan','Feb','Mar'),'Q3',

if(match(month(Date),'Apr','May','Jun'),'Q4')))) as Quarter,

Kushal_Chawda — Fri, 25 Mar 2016 07:30:09 GMT

try this also

'Q'&Ceil(num(Month(Addmonths(Date,-6)))/3)