topic Re: SET current Period to Previous Period in QlikView https://community.qlik.com/t5/QlikView/SET-current-Period-to-Previous-Period/m-p/1164584#M463704 <HTML><HEAD></HEAD><BODY><P>It would be better if you can share some raw data with expected output.</P></BODY></HTML> Thu, 09 Jun 2016 15:48:51 GMT sunny_talwar 2016-06-09T15:48:51Z SET current Period to Previous Period https://community.qlik.com/t5/QlikView/SET-current-Period-to-Previous-Period/m-p/1164583#M463703 <HTML><HEAD></HEAD><BODY><P> Hi All,</P><P></P><P>I have an issue with one of the tables that I am creating. Find the table below. I have formulas calculating the values from Q1 - Q4 and Fy depending on the Year and the Period selected (say Year : 2016 and PEriod : 5 )</P><P>I need to create one more column which should recalculate the formulas for Pevious Period. </P><P></P><P>In the formula there are other variables that are dependent on the period too. Eg: Target Period will be&nbsp; &gt;=1&lt;=4 for Period 4 and will be <SPAN style="font-size: 13.3333px;">&gt;=1&lt;=5 for Period 5.</SPAN></P><P></P><P>Is there any way I can force the Period value to be Period -1 in the begining on the caluculations so that I will be able to re use my formulas?</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 423px; height: 80px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Q1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Q2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Q3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Q4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FY</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ff0000;">FY Pre.Period</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 09 Jun 2016 15:32:07 GMT https://community.qlik.com/t5/QlikView/SET-current-Period-to-Previous-Period/m-p/1164583#M463703 2016-06-09T15:32:07Z Re: SET current Period to Previous Period https://community.qlik.com/t5/QlikView/SET-current-Period-to-Previous-Period/m-p/1164584#M463704 <HTML><HEAD></HEAD><BODY><P>It would be better if you can share some raw data with expected output.</P></BODY></HTML> Thu, 09 Jun 2016 15:48:51 GMT https://community.qlik.com/t5/QlikView/SET-current-Period-to-Previous-Period/m-p/1164584#M463704 sunny_talwar 2016-06-09T15:48:51Z