Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

maxsugak
New Contributor

How to match dates correctly

Hi,

lets say I have 2 tables with different data, but each of them has it own date information, for example:

- 1st table has fields Year,  Month, Week.

 - 2nd table has fields Year, Week.

And also I have a key field named ProductID.

What is the best way to match this two tables without synthatic key? I would use same date filter for both tables.

Thanks!  

Labels (4)
4 Replies
pradosh_thakur
Honored Contributor II

Re: How to match dates correctly

Hi @maxsugak 

 

It will be unfair without knowing the background and ask you do something to remove the synthetic key. If both the year and week corresponds to the same date like start date for example you can omit something but if they are different you may need to separate them and create date out of it. 

 

As i said there could be different ways to do it depending upon the data, some back ground of it would make our job easier.

Thanks

Pradosh

Learning never stops.
maxsugak
New Contributor

Re: How to match dates correctly

Thanks for your response!

I've made quick example attached.

 

Highlighted
maxsugak
New Contributor

Re: How to match dates correctly

SKU is a key field
Channa
Valued Contributor III

Re: How to match dates correctly

concat(year,week)

in both tables and join it will avoid synthatic key

 

synthatic key is not a problem

Channa