We’ve heard the classic expression, “There are many ways to skin a cat” Well, it is so relevant when it comes to development in Qlikview.

The fun part of Qlikview development is that it makes you think and, many times, you can achieve your goal in more than one ways.

In this tutorial, I will show you how you can unleash the power of preceding load to aggregate sales amount by each customer.

Interestingly, the dataset contains a column, customerId, which has customer name and id concatenated. We will use our creative ways to extract customer name by using few functions — left and index.

The power of Preceding Load on Preceding Load: