Fields as Key

[ajsjoshua]

Hi ,

I have two tables

Both has field LITM as common,but joining the tables i am getting mismatch values so i was instructed to make two fields as key and join the tables.

setting LITM and DistributorID as key from testcom1

and

setting LITM and Customerno as key from testcom2

But Customerno  and DistributorID are correlated fields

how to achieve this.

[varshavig12]

You want the below screenshot as the output ?

[varshavig12]

If yes, then there's no need to join the table,

QlikView will implicitly join them using the common key "LITM"

[ajsjoshua]

Hi Varsha,

i want to join the tables based on hierarchy.

[ajsjoshua]

Hi Vasrsha,

This is not my output i want make customerno and DistributorID as Hierarchy .

[varshavig12]

Ohh, Actually I cannot open your qvw.

I'm using P.E

[qliksus]

Do you want a view like this

I mean based on the common LTIM between the customer and Distributor ID you want to group the customer and distributor like this ?

[varshavig12]

May be something like how  qliksus‌‌ has posted ?

If not can you please post, what you want to see as the output.