topic Re: Pivot table - average value problem in QlikView

Pivot table - average value problem

johanfo2 — Fri, 13 Jul 2012 13:46:51 GMT

Hi,

I have an annoying problem with calculating average values in pivot

I have a 2 dimensional pivot table, horizontally is the Dates, and vertically is the Names

Now, the expression is "count(ID)" which lists then, for each name and date, how many "IDs" there are. So far so good.

Now, I have tried to replace the "count(ID)" with an expression which should compare the number of IDs with the average across time, but per name.

So, rephrase, per "name", the expression should be count(ID) / { average(count(id)) across all dates, but not across all name}

I have tried to do something like this: =avg(aggr(count(ID), Dates)) but it seems to fail.

Any suggestions?

Re: Pivot table - average value problem

Fri, 13 Jul 2012 13:52:38 GMT

try presentation tab and show partial sum

Re: Pivot table - average value problem

swuehl — Fri, 13 Jul 2012 14:02:28 GMT

Try

=count(ID) / avg(total<Names> aggr( count(id), Names, Dates))

Re: Pivot table - average value problem

johanfo2 — Fri, 13 Jul 2012 14:07:19 GMT

Outstanding! In fact, I did try something similar based on reading the documentation. Howver, I misinterpreted the "anglebrackets" to be "[" or "{", thus it failed.

Thanks a lot.