Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mremacle
New Contributor II

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

Re: How to link the dates of multiple files?

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
Esteemed Contributor

Re: How to link the dates of multiple files?

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

mremacle
New Contributor II

Re: How to link the dates of multiple files?

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
Esteemed Contributor

Re: How to link the dates of multiple files?

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 ?

mremacle
New Contributor II

Re: How to link the dates of multiple files?

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

mremacle
New Contributor II

Re: How to link the dates of multiple files?

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

Matthieu

Community Browser