Skip to main content
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Retrieving the last 8 closed Quarters YYYY'Q'QQ

Hello experts,

I need help to retrieve the last 8 closed quarters, in order to compare them with each other. And this needs to be done using set analysis.

My data format in the [Quarter] field is for example: 2018Q02

I should have the 2 last closed quarters as variables in order to perform sum and calculations between them, for example:

Quarter for today() = 2018Q04. So, as long as we need the closed quarters:

$LastQuarter = [Quarter]-1 = 2018Q02

$2LastQuarter = [Quarter]-2 = 2018Q01

Once i understand the mechanic behind it, i can try and solve the other closed quarters that i want.

I've been trying to do this, but nothing is working at this moment.

Thanks for the help!

0 Replies