In this recipe, we will go through the process of creating our own analysis from scratch in order to learn more about combining data from multiple sources. We will discuss how to stimulate thought processes in order to select criteria for a creative and meaningful analysis. In later sections, we will introduce more sheet objects and more of the QlikView interface will be explored. More scripting examples for joining data are covered.
There is an Excel spreadsheet named
Where to Retire.xls, which has multiple tabs that contain the example data. This sheet is a part of the downloadable support files.
For this analysis, I began by gathering data to load. When my spouse and I first began discussing ...