topic Group By and Average at Script level in QlikView

Group By and Average at Script level

Thu, 31 Jan 2013 07:45:39 GMT

Hey,

i want to calculate the following scenario...

ID Amount

1 10

2 20

3 30

i want to group by id and calculate average of amount at script level.

Utsav

Thu, 31 Jan 2013 07:48:11 GMT

try this

LOAD id,sum(amount) as sumamount,

avg(amount) as avgamount

FROM

(ooxml, embedded labels, table is Sheet1) Group by id;

sujeetsingh — Thu, 31 Jan 2013 07:49:24 GMT

utsav u can do it in ui level very easily ....

Juast by takinmg your id as dimention ..

er_mohit — Thu, 31 Jan 2013 07:53:53 GMT

hi try this

LOAD * INLINE [

id, amount

1, 10

2, 20

3, 30

];

LOAD

Avg(amount)as avg_amount

Resident a

Group by id;

hope it helps

khadeer — Thu, 31 Jan 2013 07:54:33 GMT

Aggr function works for that

aggr(avg(Amount),Id)