Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
50ShadesOfSalty
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