topic Re: Fields as Key in QlikView

Fields as Key

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 11 Jul 2016 08:11:30 GMT

You want the below screenshot as the output ?

varshavig12 — Mon, 11 Jul 2016 08:13:15 GMT

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

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

ajsjoshua — Mon, 11 Jul 2016 08:27:57 GMT

Hi Varsha,

i want to join the tables based on hierarchy.

ajsjoshua — Mon, 11 Jul 2016 08:45:32 GMT

Hi Vasrsha,

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

varshavig12 — Mon, 11 Jul 2016 08:52:55 GMT

Ohh, Actually I cannot open your qvw.

I'm using P.E

qliksus — Mon, 11 Jul 2016 09:13:37 GMT

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 — Mon, 11 Jul 2016 09:21:59 GMT

May be something like how qliksus‌‌ has posted ?

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