Qlik Community

Ask a Question

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nvrphanikumar
Creator
Creator

Two Tables Joined in multiple ways

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

3 Replies
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.


talk is cheap, supply exceeds demand
nvrphanikumar
Creator
Creator

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
Creator
Creator

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