Comparing 2 consecutive years - Charts showing changes between 2 years
Hello QlikView experts!
I have school attainment data (many students, several different measures) for 4 years and would like to have a bar chart showing the differences between each two consecutive years, allowing the user to select all years or only some. I thought this would be very simple to do until I actually started doing it (in QV11) and realized I couldn't find my way around. I've thought about some alternative ways (like using cyclic groups) but would really like to learn the "proper" way as this is something I will need to be doing again in future.
I'm attaching a sample qvd file and am eager to hear your suggestions.