topic Re: Compare last to first and last to previous in QlikView

Compare last to first and last to previous

Thu, 21 Feb 2013 17:22:15 GMT

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.

Re: Compare last to first and last to previous

Gysbert_Wassenaar — Thu, 21 Feb 2013 17:46:30 GMT

See attached example for one solution. I've assumed that the measurements M1 is the first, M2 the second etc. If that's incorrect you'll need to explain how to derive the correct order.

Re: Compare last to first and last to previous

Thu, 21 Feb 2013 17:55:43 GMT

That looks good for comparing to the previous measurement (it is so simple once you see it), how would you do a comparison with the first measurement? Thanks.

Re: Compare last to first and last to previous

Thu, 21 Feb 2013 18:50:15 GMT

I got it. Thanks. It is a little discouraging I didn’t see it myself, but your solution opened my eyes to using the script better. Thanks very much.

Re: Compare last to first and last to previous

Anonymous — Thu, 21 Feb 2013 20:24:39 GMT

Hi,

Can you please fiend the attachment of application.

Regards

Re: Compare last to first and last to previous

Fri, 22 Feb 2013 14:01:04 GMT

Thanks, both approaches worked. Thanks for your help.