I am new to QlikView.I have 3-4 excel files(some have same fields as well). I want each tab in qlikview using each of these excel file as data source. So I would like to know:
1.How to I import multiple excel files into QlikView and.
2. How do I make each tab having different data sources.
I'm trying to do this as well but I'm not totally following your instructions. When I try to specify the files I want to load for each table, the dimensions of same name are still being combined. For example, if I have a dimension named "pet" in file 1 and a dimension named "pet" in file 2, I want to only see the data values under "pet" from file 1 on one tab and the data values under "pet" from file 2 on the other tab. I've tried to tell the charts on each tab to reference only the relevant table from the script (i.e. Sheet3 and Sheet4) but they're still combining. Here's the script I'm using--can you help troubleshoot?
