Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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