topic select quarter in QlikView

select quarter

Anonymous — Wed, 23 Nov 2011 04:09:54 GMT

Hi folk,

Please help me to find the issue to select current quarter and previous quarter in expression or however.

I calculate the quarter:

'Q' & Ceil(Month(date)/3)& '-' & year(date) as Quarter.

Thank you so much,

rohit214 — Wed, 23 Nov 2011 04:24:28 GMT

hi vovan

why dont you write 'Q' & Ceil(Month(date)/3)& '-' & year(date) as Quarter.

means year(date)

and 'Q' & Ceil(Month(date)/3)

by doing this you can get information means at whish yaer and which quarter

thanks

rohit

Anonymous — Wed, 23 Nov 2011 15:15:21 GMT

Ho rohit,

I don't know another way to get it.

In my case I get Q1-2011, Q2-2011,Q3-2011, so on.

Could you suggest some else, I'll be appreciate it?

Thanks,

Anonymous — Wed, 23 Nov 2011 18:57:18 GMT

I found out the issue.

In script:

QuarterName(QuarterStart(submitDateTime)) as QQQ

and in expresssion:

{<QQQ={'$(=QuarterName(max(QQQ)))'}>} current quarter:

{<QQQ={'$(=QuarterName(max(QQQ),-1))'}>} last quarter.