Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor III

Previous Year's Quarter

I have tried the below expression to calculate Previous Year's quarter of current selected quarter. I have select the current quarter Oct-Dec 2017 in filter. I could not get the previous year's quarter Oct-Dec 2016?

= If(IsNull(GetCurrentSelections()) or (QuarterEnd(Max(TransactionDate)) = QuarterEnd(Today()))

, Sum({<TransactionDate  = {">=$(=(Date(QuarterStart(Max(TransactionDate ),-5),'YYYY-MM-DD'))) <=$(=(Date(QuarterEnd(Max(TransactionDate ),-5),'YYYY-MM-DD')))"} >}BilledAmount)

, Sum({<TransactionDate  = {">=$(=(Date(QuarterStart(Max(TransactionDate ),-4),'YYYY-MM-DD'))) <=$(=(Date(QuarterEnd(Max(TransactionDate ),-4),'YYYY-MM-DD')))"}>} BilledAmount))

2 Replies
baarathi
Contributor III

Re: Previous Year's Quarter

Hey stalwar1

          ‌‌ can you help me out with this?

Thanks and Regards

Baarathi

Partner
Partner

Re: Previous Year's Quarter

maybe this:

Sum( {< TransactionDate = {">=$(=QuarterStart(Max(TransactionDate),-4))<=$(=QuarterEnd(Max(TransactionDate),-4))"} >} BilledAmount )

I hope it helps.