This tool has been designed to do balancing tests between two datasets efficiently and accurately, and with little hassle. In most cases a source data extract will be used to determine if the data structure and content of your QlikView data model is balancing back to the source system and that your analysis of the data is correct.
In this example we will be using 2 small files which will be easy to cross check manually by eye but will be very difficult to do on actual large datasets as indicated in below screenshots.
Data Set 1(This represents a data extract from the source):
Data Set 2(This represents the bi end result data needed to be balance checked). Note some differences has been highlighted which has been spotted manually by eye: