Discussion Board for collaboration related to Creating Analytics for QlikView.
i want to calculate the following scenario...
i want to group by id and calculate average of amount at script level.
hi try this
LOAD * INLINE [
Group by id;
hope it helps
View solution in original post
LOAD id,sum(amount) as sumamount,
avg(amount) as avgamount
(ooxml, embedded labels, table is Sheet1) Group by id;
utsav u can do it in ui level very easily ....
Juast by takinmg your id as dimention ..
Aggr function works for that