How to load different Excel file with the same type in the run time in QlikView?
Dears,
First I want to describe my problem then ask my Question.
You imagine that there is a big company that want to generate complete report from it's sub-company.These sub company report their work in the excel file with the same format(data are different) Now,the main company make a QlikView file from one of this report ( that belong to the one sub company) but the manager of main company want to have some buttons in that qlickView file to select each of the sub company that he like and then see the report of this sub company, Now what should I do to reload the excel from other sub company by clicking on the button to this QlikView File?please pay attention that I changed the format of the excel file with enable transformation.