5 Replies Latest reply: Feb 22, 2013 9:01 AM by Bill Burkett RSS

    Compare last to first and last to previous

      I have a series of periodic measurements on patients that consist of 6 criteria per measurement. I need to find the difference between measurements comparing the most recent to the first, or the most recent to the previous. I need to compare them criterion by criterion, checking which have improved or decreased and then counting and if the number of improvements outnumber the decreased, then the patient is said to have improved. Each patient can have a different number of measurements.

       

      I am relatively new to Qlikview do not know if the best way to approach this is through the script, or if it can be done in a chart. I have tried both and had little success. Any suggestions? I have attached sample data.