I have a set of patients, encounters and types for each . I want to get the max date for each visit type by patient. I also want to get if the visit was within six months of visit where type = First, I want this to be the first date, otherwise I want to choose the date where the visit is within six months of the visit type first.
I would like to do this in the qlikview script. I have tried using variables to accomplish this.
Re: Max Date on Nested Interval in Qlikview Script
Mai, the best I have is some Design Blog posts that might give you some ideas, but you may need to search around in that area yourself, as I am not exactly sure what you are trying to do here either, there are hundreds of posts in this area, most are example/use case driven, so will hopefully give you some ideas on how to go about things.
Those are the two that I think are most likely of help, but there may be others, just back the URL up to the Qlik-Design-Blog level, and you can search from there across all the posts in just the Design Blog area. Hope this helps.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.