topic Re: avg value showing wrong in QlikView

avg value showing wrong

Mon, 28 Nov 2016 07:03:37 GMT

hi,

i have one small issue in pivot table

in avg column total average value showing wrong

please help me

what i have to did to show correct value

Re: avg value showing wrong

tresB — Mon, 28 Nov 2016 07:15:49 GMT

I guess total avg is showing correct (it is actually over all average). May be you are expecting to see total of all averages. If so, that could be achieved using Sum(aggr(Avg(... structure of formula. But before doing that I would suggest to consult your business if they really want that.

For row total (sum of all averages), try expression:

=Sum(Aggr(if(isnull(avg({$<RNUNTS_ACTIVE_ROW={Active}>} RNUNTS_RENT_IN_SQFT/RNTS_TS_PERIOD_DIV_VAL)),avg({$<RNUNTS_ACTIVE_ROW={Active}>} RNUNTS_RENT_IN_SQFT) ,avg({$<RNUNTS_ACTIVE_ROW={Active}>} RNUNTS_RENT_IN_SQFT/RNTS_TS_PERIOD_DIV_VAL))

,Project,SubProject,Lesse))

Re: avg value showing wrong

Mon, 28 Nov 2016 07:25:17 GMT

thank you tresesco

but i want the average of total value

Re: avg value showing wrong

tresB — Mon, 28 Nov 2016 07:31:48 GMT

What is your expected output (in number) as total average?

Re: avg value showing wrong

Mon, 28 Nov 2016 07:35:18 GMT

yes

Re: avg value showing wrong

Mon, 28 Nov 2016 07:36:12 GMT

average of total avg

Re: avg value showing wrong

tresB — Mon, 28 Nov 2016 07:37:51 GMT

Isn't that 22.22 ?

Re: avg value showing wrong

Mon, 28 Nov 2016 07:42:24 GMT

actually average of total value is22.59

but here showing 22.22

Re: avg value showing wrong

Mon, 28 Nov 2016 08:25:23 GMT

Re: avg value showing wrong

Mon, 28 Nov 2016 09:16:38 GMT

thank you so much gyhxmg111