Two Tables Joined in multiple ways

[nvrphanikumar]

HI,

Very new to Qlik.

I have two tables ,One Master table and One Historical table.

I would like to join both Master and Historical with common keys to get different results.

For Example:

Master has Month end Date

Historical has Transaction Dates.

Join 1# Transaction Date between Month Start Date and Month End Date

Join 2# Transaction Date between Year Start Date(Extracted from Transaction Date) and Month End Date

I would like to load both these tables and join them in Qlik with different relations.

Whats the best way to do it ?

Looking at some Youtube Video's I think it can be achieved using load inline function.

Thank you

[Gysbert_Wassenaar]

Create a Month End Date in your historical transaction table too with the same name as in your Master table. That way the records in both tables will be associated correctly.

I don't understand what you want with regards to join #2.

[nvrphanikumar]

Basically I'm trying to achieve MTD and YTD Transactions.

With Join 1#, I see your suggestion will work

Similarly Join 2#,If the Master table 1 is looking at Feb Month end, From Transaction, i would like to get all transactions until Feb end.

If I choose Oct from Master Month end,Then all transactions until Oct from Historical table.

I'm guessing I could join by using <= or something.

But my real question is,

Can I maintain two different Physical tables and  create views (Create different results set by combining both tables using different joins )

Thanks

[nvrphanikumar]

Let me Ask this in a different way.

I have

1)Job Opening Table, That has Hiring Manager ID and Recruiter ID.

2)Hiearchy Table: That has denormalized view with all the levels

I would like to set relations as

1 )Job Opening Table Hiring Manager ID +  Emplid in Hierarchy table

2) Job Opening Table Recruiter ID +  Emplid in Hierarchy table