Comparative Analysis

[mphekin12]

Hello,

I am looking for some help on using comparative analysis (unless someone can tell me a better way to handle this issue).  End users are able to select to two periods to compare data.  This part is working fine as you can see in the bottom two straigt tables.  I would like to combine these two states into one table.  The problem is that the 'Parent Term Code' changes from one period to the next and I would like to only see the 'Parent Term Code' of the Current Period.  I was able to get two of the three codes, but I needed to add the 'Length' field and then use the following expression for the 'Parent Term Code':

  =aggr(MaxString({[PrevPeriod]} ParentTermCode),School,StartDateDate,Status,Length)

Is there a better way to handle this issue so that all three Current Period Parent Term Codes are displayed with their associated student counts from the current and previous period?

Any help would be greatly appreciated!

[mphekin12]

Is there anyone out there that has experience with comparative analysis in QlikView 11 that might be able to help with this problem?

Thank you!