Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how to get previous Quarter

I used the following formula to get the quarter selected

= 'Q' & ceil(Month(max(MonthName))) / 3 &', '& Year((max(MonthName)))

so when i select a month it give me the quarter as  Q4,1012

now if i want to get the previos quarter how can i do that. For the month its easy but for quarter no idea at all

PLEASSEEEEEEE HELPPP

1 Reply
Not applicable

Re: how to get previous Quarter

Hi,

U have this('Q' & ceil(Month(max(MonthName))) / 3 &', '& Year((max(MonthName)))) as field ryt?

if yes  U can use previous function to get previous Quarter like below

=previous(Quarter)

~Kabilan K.

Community Browser