topic Aggr Expression in QlikView

Aggr Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi Developers,

I have a requirement to convert normal if condition expression to aggr expression.

If Condition Expression:

((sum( if(Payor_ID = 'MDTX' and Adjudicated=0 and High_Risk_NIPT = 'yes' and (Test_Family_2 = 'NIPT' or Test_Family_2 = 'NIPTMD'),

High_Risk_Medicaid*.8,

if(Payor_Group_3 = 'State Medicaid' and Adjudicated=0 and High_Risk_NIPT = 'yes' and (Test_Family_2 = 'NIPT' or Test_Family_2 = 'NIPTMD'),

High_Risk_Medicaid)))

sum( if(Payor_Group_3 = 'State Medicaid' and Adjudicated=0 and Test_Family_2 = 'HCS', HCS_Medicaid))

)/Count(distinct Accession_ID)

)* %Medicaid_attainable

AGGR Expression (I wrote):

((sum(aggr((if(Payor_ID = 'MDTX' and Adjudicated=0 and High_Risk_NIPT like 'Yes' and (Test_Family_2 = 'NIPT' or Test_Family_2 = 'NIPTMD'),

High_Risk_Medicaid*.8,

if(Payor_Group_3 = 'State Medicaid' and Adjudicated=0 and High_Risk_NIPT = 'yes' and (Test_Family_2 = 'NIPT' or Test_Family_2 = 'NIPTMD'),

High_Risk_Medicaid))), Accession_ID))

sum(aggr((if(Payor_Group_3 = 'State Medicaid' and Adjudicated=0 and Test_Family_2 = 'HCS', HCS_Medicaid)), Accession_ID)))

/ count(distinct Accession_ID)) * %Medicaid_attainable

I have just modified sum calculation to distinct Accession_ID.

But surprisingly its not working(I mean am not getting equal vales for both expressions)

Can someone please help me to solve this?

Thanks in advance

Thanks,

Rohini. M

Anil_Babu_Samineni — Wed, 19 Oct 2016 01:53:07 GMT

Would you be able to provide application which demonstrates the o/p

Wed, 19 Oct 2016 17:13:06 GMT

Sorry Anil I cannot provide the application. But here is the sample output.

Am not getting equal amount for both expressions. I am just testing whether my aggr expression is correct or do I need to do some changes.