If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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 :
Thank You Qlikxperts ...
Attached file for reference .
this script should work
LOAD Client,ProductType,RegionFROMGRANULARITY.xlsx(ooxml, embedded labels, table is [Table 1]);
Right JoinLOAD [Product Levl 1]as ProductType,[Product Levl 2],[3Product Levl 1]FROMGRANULARITY.xlsx(ooxml, embedded labels, table is [Table 2]);
Left JoinLOAD Client,ProductType as [3Product Levl 1],INCOME,RegionFROMGRANULARITY.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