topic Re: Can there be a SUM() function in the Preceding Load? It is not working for me. If not, why is that not allowed? in QlikView

Can there be a SUM() function in the Preceding Load? It is not working for me. If not, why is that not allowed?

Thu, 17 Mar 2016 20:09:38 GMT

Can there be a SUM() function in the Preceding Load? It is not working for me. If not, why is that not allowed?

Thanks!

sunny_talwar — Fri, 18 Mar 2016 08:47:48 GMT

Yes you can have Sum (with a group by statement) in preceding load.

Kushal_Chawda — Fri, 18 Mar 2016 08:50:45 GMT

Yes, you can write in preceding load. see this

tresB — Fri, 18 Mar 2016 08:55:03 GMT

You can. You have to just be careful about the Group By clause. Try like:

Load

Sum(Sales) as TotalSales

Country

Group By Country;

Load

From <>:

Colin-Albert — Fri, 18 Mar 2016 08:56:55 GMT

To use any aggregation in the load script; sum, count, max etc, there must be a "group by" clause.