Discussion Board for collaboration on QlikView Scripting.
Dear colleagues, good day!
In load script i load table from excel with two fields:
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
Go to Solution.
avg(Sum) as Sum
Group By Id;