topic Re: how to link two tables in QlikView

how to link two tables

Mon, 20 Oct 2014 11:30:55 GMT

Hi Friends

I have two tables like this

H Desc G Desc

1 XXX 9 AAAA

2 YYY 10 BBB

C ZZZ 11 CCC

And combination of H and G Will lead to diffirent Desc

H G Desc

1 9 DDDD

2 10 EEEE

So How if the user selects 1 desc should be XXX , 2 shoud be AAAA

And if user selects 1 and 9 both together Desc should be DDDD.

Thanks

Re: how to link two tables

anbu1984 — Mon, 20 Oct 2014 11:39:49 GMT

How did you combine two tables based on row numbers?

What is the logic to get new Desc?

H G Desc

1 9 DDDD

2 10 EEEE

Re: how to link two tables

PradeepReddy — Mon, 20 Oct 2014 11:48:24 GMT

Can you provide some sample data.. and on which basis u are joining both tables?

Re: how to link two tables

Anonymous — Mon, 20 Oct 2014 12:16:59 GMT

Hi,

Your logic is not understandable.

Please elaborate more as Qlikview Engine can join two tables with a common field in them ,in your case there is DESC (as a common field ).

When Qlikview Engine joins, it will use outer join to join both of your tables (as it is according to the data which you have provided for DESC field)

and when you select any field values of FIELDs(H or G),it will give their corresponding value of DESC Field and not the one you explained.

Hope you understand my point.

Thanks,

Geeta