topic Re: avg in QlikView

avg

Anonymous — Thu, 31 Dec 2015 06:13:27 GMT

hi,

i made formule in pivot & chart like this avg(if,than.if(than, if(than,else),else))...

the resolt in the line is O.K. but in sum the resolt is not good

exm:

resolt line 1 - 4

resolt line 2 - 17

resolt line 3 - 7

in the sum line it's show 4 !!

what can be the problem ?

thanks'

yarin

lironbaram — Thu, 31 Dec 2015 06:49:55 GMT

the problem is that

qlikview evaluates the formula for the total field also and apparently it answers the first condition

you'll need to use this as your expression

sum(aggr( avg(if,than.if(than, if(than,else),else)),YourDimensions))

Anonymous — Thu, 31 Dec 2015 06:51:43 GMT

Can you post your expression for Sum

Thanks

PrashantSangle — Thu, 31 Dec 2015 07:06:30 GMT

Hi,

Can you post screen shot of your chart???

Try aggr()

try like avg(aggr(YourExpression,dim))

Regads

HirisH_V7 — Thu, 31 Dec 2015 07:37:24 GMT

Hi ,

I hope ,

In your expression ,

(if,than.if(than, if(than,else) Its fine but you have to aggr for the final else with your dimensions,

Can you post your sample if possible,

-Hirish

yevgeniy — Thu, 31 Dec 2015 12:26:22 GMT

Hi,

avg(aggr(avg(if,than.if(than, if(than,else),else)), your dimention fields1,your dimention field2....))