Multiple data sets with dates and one start & end date selection

Sat, 16 May 2015 19:43:18 GMT

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

Re: Multiple data sets with dates and one start & end date selection

Agis-Kalogiannis — Mon, 18 May 2015 08:25:35 GMT

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

topic Multiple data sets with dates and one start & end date selection in QlikView

Multiple data sets with dates and one start & end date selection

Re: Multiple data sets with dates and one start & end date selection