Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

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!