Growing up in the Finance area of banks and other Fin Serv companies, I often found myself capturing data from multiple sources, consolidating in a spreadsheet table and storing data with a filename for each month. This is one of the most common practices with subject matter experts who use Excel as a primary means of reporting. Here is a great post by QlikTech's hic
who provides a solution extremely relevant to those who want to capture this data in QlikView and deliver Self-Service BI to their users.
Lucky for me I have no longer have any use for excel (except for the storing of some flat data) and have an immediate need in one of my everyday apps that I have built to apply this logic.
Anybody using this script in their QlikView apps?