topic Re: avg in QlikView

avg

Anonymous — Thu, 18 Jul 2013 03:40:18 GMT

hi,

i want to make avg for sum feild.

i wrote:

afg(kgperhour).

but the result is not correct .

what i did wrong ?

thanks'

yarin.

sujeetsingh — Thu, 18 Jul 2013 03:52:35 GMT

you have written afg it should be avg()

Sokkorn — Thu, 18 Jul 2013 06:25:29 GMT

Hi Yarin,

Using afg(kgperhour) is not the right one. In QlikView we can use:

1. Expression: Avg(kgperhour)

2. Expression: Sum(kgperhour) then select Average in total mode

Regards,

Sokkorn

Thu, 18 Jul 2013 06:28:37 GMT

HI.

Instead of write afg(kgperhour),pls write Avg(kgperhour).

er_mohit — Thu, 18 Jul 2013 06:30:59 GMT

you have to write in expression side of any chart object

and aggr to that dimension on what you want the right answer

aggr(avg(Fieldname),dimensionfieldname)