Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cbutcher
Partner - Contributor II
Partner - Contributor II

How to calculate Offset Periods

I Need a little help

In the attached application I need the Calc2 column to calculate the Current selection by month + the offset value i.e.

If I select 201001, 201002 and 201003 (April2010, May2010 and June2010)

I need the calc2 to be April2010 + May2009

May2010 + June2009

June2010 + July2009

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.

Any pointers would be great

Thanks

Chris

0 Replies