topic Re: Pivot Table: Get AVG when Collapsing Table in QlikView

Solved

microwin88x — Fri, 11 Dec 2015 02:25:03 GMT

Solved

settu_periasamy — Fri, 11 Dec 2015 02:56:31 GMT

May be try with Aggregation. Like

=IF(CATEGORY='Assessment' OR CATEGORY='Payment',

Aggr(SUM(SECONDARY_TIME)/COUNT(DISTINCT NUM_PROCEDURE),CATEGORY,SUBCATEGORY),

Aggr(SUM({$<FLAG_PHASE={'1'}MAIN_TIME)/COUNT({$<FLAG_PHASE={'1'}DISTINCT NUM_PROCEDURE),

CATEGORY,SUBCATEGORY) )

microwin88x — Fri, 11 Dec 2015 03:13:04 GMT

Uhm, I've tried that but I still get Null

settu_periasamy — Fri, 11 Dec 2015 03:30:35 GMT

Can you Post the Sample?

May be try this. sum before Aggr. Like

=IF(CATEGORY='Assessment' OR CATEGORY='Payment',

Sum(Aggr(SUM(SECONDARY_TIME)/COUNT(DISTINCT NUM_PROCEDURE),CATEGORY,SUBCATEGORY)),

Sum(Aggr(SUM({$<FLAG_PHASE={'1'}MAIN_TIME)/COUNT({$<FLAG_PHASE={'1'}DISTINCT NUM_PROCEDURE),

CATEGORY,SUBCATEGORY) ))

jagan — Fri, 11 Dec 2015 03:43:22 GMT

Hi,

Try like this using Aggr() like below

Sum(Aggr(IF(CATEGORY='Assessment' OR CATEGORY='Payment',

SUM(SECONDARY_TIME)/COUNT(DISTINCT NUM_PROCEDURE), (1)

SUM({$<FLAG_PHASE={'1'}MAIN_TIME)/COUNT({$<FLAG_PHASE={'1'}DISTINCT NUM_PROCEDURE)), USER,CATEGORY,SUBCATEGORY))

microwin88x — Fri, 11 Dec 2015 04:27:26 GMT

Thanks! I used it with AVG(AGGR()) on the outside and it worked!!!