I'm really new at this and I just need some help for a project I got assigned to on my student job.
The thing is that there are monthly files from check ups on the company and they would like to use Qlik to analyze the data. Now this has to go as easy as possible so I thought of the following structure.
Every month, the same excel file can be dropped in a map. Only with a different number. Now every time we open the app I make in Qlik, the new file should load. And the "older" files also need to stay in the app as we need to see the evolution over the months.
Now I searched for many things and found the LOAD function and RELOAD functions but I just can't understand how I need to write this in my code, I'm not a very good code writer...
I just realy hope someone has experience with this kind of structure and can help me do this or advice me to do something else or I don't know what.
If there are any questions about this, please let me know and I will answer them so everything is clear.
Ok I have now a script that loads all files from a map, but how can you get the data from each file? I would like to have 2 sheets. One for the last month overview and one for the overall time where you can see the positive or negative movements per month. Now the data used in the charts automaticly uses the sum of all the files. How do I make the difference between the files?