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.

       

      Marketa