Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Sunny,
As said here is the new copy. Please do the needful.
Appreciate your time.
Thanks,
V.
Second last expression
= RangeMin( Aggr(RangeMax(ONLY({1} Aggr(
CEIl(
(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
, '##.00')
-
NUM(Min({1} TOTAL Aggr(RangeMin(ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)), '###0')
)
/
(
(
(
Num(Max({1} TOTAL Aggr(RangeMax( ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)), '###0')
)
-
(
Num(Min({1} TOTAL Aggr(RangeMin(ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)),'###0')
)
)/10
)
,1)
,PROVIDER))), PROVIDER))
Can you explain what is the issue? which object do you need help with? and what exactly are you looking for?
My mistake. Wrong qvw file. Apologies for that. Uploaded the latest one to original thread.
In that table we have 3 risk score ratings. When i select a Name from the listbox it should show the rating number.
Like here when i select a name, the number is gone.
It's 89 MB. Can you post expression for missing the value?
PFA... I have just modified so that the values show up even after selections are made, but I think that this expression can be improved a lot... seems like you have some unnecessary Aggr() function which might give you bad performance
Hey Sunny,
Thanks very much for looking into this. I know the file is too big. That's hitting me back though. ;-). I should have reduced. Now i am facing difficulties downloading the one you attached. Any chances to paste the expression you used.
V.
Second last expression
= RangeMin( Aggr(RangeMax(ONLY({1} Aggr(
CEIl(
(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
, '##.00')
-
NUM(Min({1} TOTAL Aggr(RangeMin(ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)), '###0')
)
/
(
(
(
Num(Max({1} TOTAL Aggr(RangeMax( ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)), '###0')
)
-
(
Num(Min({1} TOTAL Aggr(RangeMin(ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)),'###0')
)
)/10
)
,1)
,PROVIDER))), PROVIDER))
Last expression
= RangeMin( Aggr(RangeMax(ONLY({1} Aggr(
CEIl(
(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
, '##.00')
-
NUM(Min({1} TOTAL Aggr(RangeMin(ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)), '###0')
)
/
(
(
(
Num(Max({1} TOTAL Aggr(RangeMax( ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)), '###0')
)
-
(
Num(Min({1} TOTAL Aggr(RangeMin(ONLY({1} AGGR(
Num((sum({1}aggr(sum({1<attributedrank ={1}>}individual_disctint_icd_code),person_nbr)) /
sum({1}aggr(count(distinct {1<attributedrank = {1}>}person_nbr),PROVIDER)))
,'##.00'),
PROVIDER))), PROVIDER)),'###0')
)
)/10
)
,1)
,PROVIDER))), PROVIDER))
Yes Anil, I am sure it is big, i did it in a hurry. I am trying Sunny expression, so will let you know too.
Thanks
V.
Thats superb. Thanks a lot sunny appreciate that. I hope you dont hate me. So sorry for confusing you with the last expression. In the last expression, it is a combination of 3 expressions. I know i am asking too much, you dont have to do it, but if any free time, please do let me know. So in the same file i sent, you have three expressions as shown in the image below. Combination of those 3 expr we have a field named Weighted Chronic Score which has a formula:
= ([% with 1-3 Chronic Diseases] * 0.25) + ([% with 4 - 5 Chronic Diseases] * 0.35) + ([% with >=6 Chronic Diseases] * 0.4)
Can we get this formula straight into our actual Rating Score expr that goes in last column.