nested aggregation and set analysis

Anonymous — Thu, 16 Jan 2014 14:44:03 GMT

Hi, I have hard time understanding the difference between this two expressions. I think they should return the same thing but the second one should work faster. Am I right?

Avg({$<[Place of Service Code]={11}>}

Aggr

( Max( %CHARGE_ENTRY_DAY_KEY) - Max( %SERVICE_DAY_KEY)

,%PATIENT_ENCOUNTER_ID, [CPT Code]

)

Avg(

Aggr

( Max( {$<[Place of Service Code]={11}>} %CHARGE_ENTRY_DAY_KEY) - Max( {$<[Place of Service Code]={11}>} %SERVICE_DAY_KEY)

,%PATIENT_ENCOUNTER_ID, [CPT Code]

)

Re: nested aggregation and set analysis

Anonymous — Thu, 16 Jan 2014 17:46:21 GMT

i did some tests and looks like while results are the same, the second expression works 2-3 times faster. I guess it makes sense because aggr filters data first so outer aggregation has less data to work with.

topic nested aggregation and set analysis in QlikView

nested aggregation and set analysis

Re: nested aggregation and set analysis