topic Retrieving the last 8 closed Quarters YYYY'Q'QQ in QlikView https://community.qlik.com/t5/QlikView/Retrieving-the-last-8-closed-Quarters-YYYY-Q-QQ/m-p/115493#M17788 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Hello experts,</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">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.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">My data format in the [Quarter] field is for example: 2018Q02</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I should have the 2 last closed quarters as variables in order to perform sum and calculations between them, for example:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Quarter for today() = 2018Q04. So, as long as we need the closed quarters:</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">$LastQuarter = [Quarter]-1 = 2018Q02</SPAN></P><P style="font-size: 13.3333px;">$2LastQuarter = [Quarter]-2 = 2018Q01</P><P style="font-size: 13.3333px;">Once i understand the mechanic behind it, i can try and solve the other closed quarters that i want.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I've been trying to do this, but nothing is working at this moment.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks for the help!</P></BODY></HTML> Thu, 18 Oct 2018 08:28:22 GMT 50ShadesOfSalty 2018-10-18T08:28:22Z Retrieving the last 8 closed Quarters YYYY'Q'QQ https://community.qlik.com/t5/QlikView/Retrieving-the-last-8-closed-Quarters-YYYY-Q-QQ/m-p/115493#M17788 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Hello experts,</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">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.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">My data format in the [Quarter] field is for example: 2018Q02</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I should have the 2 last closed quarters as variables in order to perform sum and calculations between them, for example:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Quarter for today() = 2018Q04. So, as long as we need the closed quarters:</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">$LastQuarter = [Quarter]-1 = 2018Q02</SPAN></P><P style="font-size: 13.3333px;">$2LastQuarter = [Quarter]-2 = 2018Q01</P><P style="font-size: 13.3333px;">Once i understand the mechanic behind it, i can try and solve the other closed quarters that i want.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I've been trying to do this, but nothing is working at this moment.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks for the help!</P></BODY></HTML> Thu, 18 Oct 2018 08:28:22 GMT https://community.qlik.com/t5/QlikView/Retrieving-the-last-8-closed-Quarters-YYYY-Q-QQ/m-p/115493#M17788 50ShadesOfSalty 2018-10-18T08:28:22Z