Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to link the dates of multiple files?

Hello, I have several files (Payroll, PostProduction and SalariesCharges), on these 3 files, I have a column which is called respectively: Paie.Mois, PostProduction.mois and SalariesCharges.Mois.

That's my problem to make my apps and calculations, I need to be able to link these dates so that when I select January for example, it will bring me the January data I need in these 3 files.

Could you tell me the procedure and the code to set up in order to succeed this please?

Regards,

Matthew

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Download the Qlik Sense version of this tutorial:

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

YoussefBelloum
Champion
Champion

Hi Matthieu,

if you're looking for the solution to your actual data, please try to attach files containing some rows from each table you have (payroll, postproduction, salaires charges...)

Otherwise, it is a very common problem when it comes to modeling data.

From what you described above, the solution I have in mind is to CONCATENATE your tables, create aliases on each load (flags), rename every month field from every table to Month (should be the same field name, no matter what..) and link that Month field to your master calendar.

hope it is clear enough.

don't hesitate to read the book mentioned by Rob above for the best approaches, best practices etc

Anonymous
Not applicable
Author

Thanks for your help, i solve my first issue with concatenate tables. So now, i have a new issue if i want to apply a filter by the fild Client-Société, it don't find the infos of the fields Salaires Chargés Primé.

In my tables, i mapped only Date and Nom-Prénom because on the different tables they are the only same fields.

Could you help me please ?

Matthieu

Problème.PNGProblème1.PNG

YoussefBelloum
Champion
Champion

Hi,

I can't tell why you can't find your infos before seeing the script, the tables structures before the concatenation and after the concatenation.

would you be able to share your QVF ? or attach excel files that contains rows from each of your tables ?

Anonymous
Not applicable
Author

I work on qlik sense cloud free, how can i do to share you my qvf ?

Anonymous
Not applicable
Author

Thanks for your Help, I found my solution on an other Topic

Matthieu