0 Replies Latest reply: May 22, 2014 11:19 AM by Marketa Canayaz RSS

    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.


      Thank you very much in advance.


      Brest wishes.