Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking to use one user defined start and end date which works across multiple data sets.
This will be an employee "score card." The only similar fields that exist are employee name. I want to select a start and end date and the sheet will show:
1.) The date(s) and cours names that the employee has completed trainings (from the training data set)
2.) The amount of sales ($) during the same period of time (from the sales data set)
3.) The number of customers visited by during the period of time (from the customer visits data set)
I have tried a lot of different options from the forums and none seem to work.
Thanks
If by data set you mean different QLikView applications, what you can do is to link them by using a linked table. The linked table will work as the Master calendar table that will connect the three datasets.
It requires a bit more complicated scripting, but eventually, this will give you what you want.
So what you can do from now on, is to focus on how to create a link table when you have multiple date fields.
I hope this helps
Agis