Discussion Board for collaboration related to QlikView App Development.
Can we use sum function on script level i.e at the time of loading?
You can use Sum(), Max(),...aggregate functions in script, but you need to group the dimensions. Check below example
Sum(Dim3) AS Sales
GROUP BY Dim1, Dim2;
Note:The fields specified in Load statement must contain in Group by, otherwise you will get error.
Hope this helps you.
what about Dim3 ,should it also be in Group By ?
The dimensions which are using in Aggregate functions like Sum() need not to be in Group by.
see this script
load * inline [
LOAD invoiceno,Sum(amount) as newamount Resident b Group by invoiceno ;