Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

Thanks!

4 Replies
Highlighted

Re: 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.

Highlighted

Re: 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 write in preceding load. see this

Benefit of using Preceding load ..

Highlighted
MVP
MVP

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

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 <>:

Highlighted

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

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