Discussion Board for collaboration related to QlikView App Development.
I'm trying to load data from an Iseries.
And every bookyear is in another Company and also an other filepath(accesspath)
I have an excel with Year and CompanyNumber.
I have only need to refresh the last 2 years (current year and CurrentYear -1)
Now I need to do a select like this
Here is an example of my script where my BoekLib (in Yellow) is empty...
How can I fill up "BoekLib"?
Everything was working fine.
But if I try to use it for another file I get some strange things...
Fot the file PBD he is filling one table "PBD
If I do the same for the PBP file he is making 2 tables PBP and PBP-1
Why is he doing this
And this is the excel I'm using for both the scripts