Qlikview - join two table

[Anonymous]

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 · Accepted solution]

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]

Thanks a lot!!