topic How to calculate Offset Periods in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-Offset-Periods/m-p/197826#M501132 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I Need a little help</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">In the attached application I need the Calc2 column to calculate the Current selection by month + the offset value i.e.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">If I select 201001, 201002 and 201003 (April2010, May2010 and June2010)</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I need the calc2 to be April2010 + May2009</P><P style="margin: 0cm 0cm 0pt;">May2010 + June2009</P><P style="margin: 0cm 0cm 0pt;">June2010 + July2009</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">The calculations are there for both in separate columns but I can't get it to calculate in the same column against the currently selected Periods.</P><P style="margin: 0cm 0cm 0pt;">Any pointers would be great</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Thanks</P><P style="margin: 0cm 0cm 0pt;">Chris</P><P style="margin: 0cm 0cm 0pt;"></P></BODY></HTML> Wed, 02 Feb 2011 15:36:30 GMT cbutcher 2011-02-02T15:36:30Z How to calculate Offset Periods https://community.qlik.com/t5/QlikView/How-to-calculate-Offset-Periods/m-p/197826#M501132 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I Need a little help</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">In the attached application I need the Calc2 column to calculate the Current selection by month + the offset value i.e.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">If I select 201001, 201002 and 201003 (April2010, May2010 and June2010)</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I need the calc2 to be April2010 + May2009</P><P style="margin: 0cm 0cm 0pt;">May2010 + June2009</P><P style="margin: 0cm 0cm 0pt;">June2010 + July2009</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">The calculations are there for both in separate columns but I can't get it to calculate in the same column against the currently selected Periods.</P><P style="margin: 0cm 0cm 0pt;">Any pointers would be great</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Thanks</P><P style="margin: 0cm 0cm 0pt;">Chris</P><P style="margin: 0cm 0cm 0pt;"></P></BODY></HTML> Wed, 02 Feb 2011 15:36:30 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Offset-Periods/m-p/197826#M501132 cbutcher 2011-02-02T15:36:30Z