Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

andreyfcdk91
New Contributor III

Avg sum in double Keys in load script

Dear colleagues, good day!


In load script i load table from excel with two fields:

Id,

Sum


What i need: if field Id has only one Sum - in this case to save the same value

                    if field Id has more than one Sum - calculate avg Sum.


There are model and source file in attachment.


Best regards, Andrey

Thanks.

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Avg sum in double Keys in load script

LOAD

Id,

avg(Sum) as Sum

FROM...

Group By Id;

2 Replies
mov
Esteemed Contributor III

Re: Avg sum in double Keys in load script

LOAD

Id,

avg(Sum) as Sum

FROM...

Group By Id;

andreyfcdk91
New Contributor III

Re: Avg sum in double Keys in load script

Many thanks.

Community Browser