Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts ,
Even though i am new to Qlik but , i have learnt a lot from community about join , yet somehow not sure about below problem statement . Sorry in advance , if i have asked something "no brainier" .
I have two tables , using which i need a resulting table which depicts dimension drill down .
Table 1 :
Client | ProductType | INCOME | Region |
Merck | Cash | 200 | US |
Merck | CashX | 100 | US |
Merck | AUS Val | 100 | US |
Merck | Local Draws | 25 | US |
Merck | Bonds | 75 | US |
Merck | Share | 50 | US |
Merck | Debentures | 50 | US |
INV | Cash | 300 | GB |
INV | CashX | 120 | GB |
INV | AUS Val | 180 | GB |
INV | Local Draws | 60 | GB |
INV | Bonds | 60 | GB |
INV | Share | 180 | GB |
Table 2
Product Levl 1 | Product Levl 2 | 3Product Levl 1 |
Cash | CashX | Local Draws |
Cash | CashX | Bonds |
Cash | AUS Val | Share |
Cash | AUS Val | Debentures |
Resulting Table
Corp | Region | Product | Product Levl 2 | 3Product Levl 1 | INCOME |
Merck | US | Cash | CashX | Local Draws | 25 |
Merck | US | Cash | CashX | Bonds | 75 |
Merck | US | Cash | AUS Val | Share | 50 |
Merck | US | Cash | AUS Val | Debentures | 50 |
INV | GB | Cash | CashX | Local Draws | 60 |
INV | GB | Cash | CashX | Bonds | 60 |
INV | GB | Cash | AUS Val | Share | 180 |
INV | GB | Cash | AUS Val | Debentures | - |
Thank You Qlikxperts ...
Attached file for reference .
Hi,
this script should work
LOAD Client,
ProductType,
Region
FROM
GRANULARITY.xlsx
(ooxml, embedded labels, table is [Table 1]);
Right Join
LOAD [Product Levl 1]as ProductType,
[Product Levl 2],
[3Product Levl 1]
FROM
GRANULARITY.xlsx
(ooxml, embedded labels, table is [Table 2]);
Left Join
LOAD Client,
ProductType as [3Product Levl 1],
INCOME,
Region
FROM
GRANULARITY.xlsx
(ooxml, embedded labels, table is [Table 1]);
Thank You StarinieriG . Can similar join logic be used for second table where we have granularity like
Product level 1 , 2, 3 , 4 , 5 ..
I think that it should work