Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
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.
Hi,
Can you please fiend the attachment of application.
Regards
Thanks, both approaches worked. Thanks for your help.