topic Re: How to get summary from firstsortedvalue? in QlikView

How to get summary from firstsortedvalue?

baylor2016 — Sat, 16 Nov 2024 04:22:28 GMT

Hi,

I was able to get the last BMI status (underweight, healthy weight, overweight and obesity) by using FirstsortedValue for each patients by using PAT_NAME AND PAT_ID as dimension,

=FirstSortedValue( distinct
{$<YearMonth,
BMI={'>0'},
VISITTYPE={'Office visit'},

CONTACT_DATE ={"$(='<=' & Date(enddateSelected))"}>} INTBMI, -CONTACT_DATE)

I would like to know how to get the summary for all the patients - the patient number for each BMI category. I thought it might need use AGGR function. But I have not clue how to get it done.

Please help.

Thanks

Re: How to get summary from firstsortedvalue?

rubenmarin — Thu, 21 Feb 2019 21:24:25 GMT

Hi, maybe adding it as dimension:
=Aggr(FirstSortedValue( distinct
{$<YearMonth,
BMI={'>0'},
VISITTYPE={'Office visit'},
CONTACT_DATE ={"$(='<=' & Date(enddateSelected))"}>} INTBMI, -CONTACT_DATE), PAT_ID)

And Count(Distinct PAT_ID) as expression

Re: How to get summary from firstsortedvalue?

baylor2016 — Thu, 21 Feb 2019 21:27:48 GMT

Great! Works perfectly!