Discussion Board for collaboration related to QlikView App Development.
Can there be a SUM() function in the Preceding Load? It is not working for me. If not, why is that not allowed?
Yes you can have Sum (with a group by statement) in preceding load.
Yes, you can write in preceding load. see this
Benefit of using Preceding load ..
You can. You have to just be careful about the Group By clause. Try like:
Sum(Sales) as TotalSales
Group By Country;
To use any aggregation in the load script; sum, count, max etc, there must be a "group by" clause.