topic Re: Conditional Join in QlikView

Conditional Join

Anonymous — Thu, 18 Jul 2013 22:05:39 GMT

Trying to Join same table twice but with two different conditions:

HeadCount:
Load
Region,
EmpID,
Unit
From HeadCount.qvd;

Left Join (HeadCount)
Load
Unit,
Region,
Final_Unit
From UnitInfo.xlsx
(ooxml, embedded labels, table is Sheet1)
Where Unit <> 'Commodities';

Left Join (HeadCount)
Load
Unit,
Region,
EmpID,
Final_Unit
From UnitInfo.xlsx
(ooxml, embedded labels, table is Sheet1)
Where Unit = 'Commodities'

First left join should join by Unit and Region and second should joing by Unit, Region and EmpID, but above approcah does not seem to work.

swuehl — Thu, 18 Jul 2013 23:03:37 GMT

Second Join will also join on Final_Unit, won't it?

Anonymous — Thu, 18 Jul 2013 23:24:17 GMT

Yeah, i guess. But do you understand what I'm trying to achieve ? FinalUnit joined in but in two different ways.

I need FinalUnit joined in but in two different ways.

Thank you.

jolivares — Fri, 19 Jul 2013 01:39:34 GMT

Try to change the name of field FinelUnit of the first table, before the join.

Anonymous — Fri, 19 Jul 2013 12:57:23 GMT

Thank you Jolivares. I had to introdue another field for second join and then on my chart used conditional dimension to pull the right one.