I am working on a hospital database and table details are
Patient number Dischargeto Date Time
212 Hospital1 16/10/2018 14:00
212 Hospital2 18/10/2018 10:00
212 Hospital3 20/10/2018 18:00
212 Home 22/10/2018 10:00
213 Hostpital1 11/11/2018 11:00
213 Death 14/11/2018 18:00
I was trying to make a Barchart with dimensions as Dischargeto and measures as 'Count(Patientnumber)
Ques 1:
In this bar chart I don't want final destination as Death so want to use where clause( as said in Sql) where dischargeto <> death, how should I do In Qlik sense?
Ques 2:
Now I have to report on patients final destination - which here will be home, it can be rehab or other options too else death. I want to filter this data on the base of latest date and time - I work in sql normally so I would have ordered on the patientnumber, date and time , or partition by patient number and then order by date and time and pick the top most entry as final destination. How should I do I Qlik sense - please advise?
