Ooo interesting question.
Aside from the usual issues one of the things that particularly stands out for me in the health care sector is the need for time or period based analysis. For example patient "spells" may comprise of several "episodes" of care that are defined by being within an arbitrary time period of each other. Sometimes the definitions can be quite tricky and the patients movements hard to follow.....
This can be tricky to script. Even "latest value" queries in languages like SQL require joining tables to themselves etc.
Qlikview I would say is average at it but has a massive advantage in that I'm not so worried about scripting an extra column to mark latest / earliest values or link periods of time into spells etc as the memory used isn't going to be a problem.
What would you say?
Erica
