Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator 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
Creator III
Creator III

Hey stalwar1

          ‌‌ can you help me out with this?

Thanks and Regards

Baarathi

Partner
Partner

maybe this:

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

I hope it helps.