topic Re: Qlikview - join two table in QlikView

Qlikview - join two table

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

hi all,

i need to join two table in Qlikview to get result.

Table:

I need to join this two table to get result table like this

Any idea? Can i use cross table and how?

sunny_talwar — Tue, 02 May 2017 15:33:38 GMT

May be like this

Table:

CrossTable(Location, Quantity)

LOAD * INLINE [

Reason, LocA, LocB

R1, 5, 2

R2, 4, 2

R3, 5, 3

R4, 3, 5

];

Right Join

LOAD * INLINE [

Location, Reason, Answer

LocA, R1, Yes

LocA, R2, No

LocA, R3, Yes

LocB, R1, Yes

LocB, R3, No

LocB, R4, No

];

Anonymous — Wed, 03 May 2017 10:13:09 GMT

Thanks a lot!!