Community
This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!