topic Re: joining requirement, help required in set analysis in QlikView

joining requirement, help required in set analysis

svsudhakar — Thu, 30 Oct 2014 07:31:21 GMT

Hi ,

Need help on below issue.

I have two tables A,B

Table A

LUSERID
LOCID

AUSERID

Table B

USERID

LOCID

Value

I need to show the LUSERID,LOCID wise values and as well as AUSERID,LOCID wise value.

if I create the key like LUSERID&LOCID from table A and USERID&LOCID from table B values are matching, but Auserid report not coming.

if I create the key like AUSERID&LOCID from table A and USERID&LOCID from table B values are matching, but luserid report not coming.

how I can show in one report both values.

Re: joining requirement, help required in set analysis

alexandros17 — Thu, 30 Oct 2014 07:34:47 GMT

do not create keys just:

TableA

left join

TableB

Let me know

Re: joining requirement, help required in set analysis

Thu, 30 Oct 2014 07:44:52 GMT

Hi,

Table A

Left(Table A)

Table B:

or else use Left Keep

Re: joining requirement, help required in set analysis

its_anandrjs — Thu, 30 Oct 2014 07:45:19 GMT

One possible way also join this tables and make use of Order BY

TableA:

LUSERID
LOCID

AUSERID

Left Join(TableA)

TableB:

USERID

LOCID

Value

Noconcatenate

Load

LUSERID
LOCID

AUSERID

USERID

Value

Resident TableA

Order BY LUSERID,AUSERID,LOCID;

Drop Table TableA;

Regards

Anand

Re: joining requirement, help required in set analysis

svsudhakar — Thu, 30 Oct 2014 07:45:30 GMT

Hi Thanks for your reply..

Is there any way to get the values with out join because other tables are linked to table A. If I do the join it will effect the other reports.

Re: joining requirement, help required in set analysis

svsudhakar — Thu, 30 Oct 2014 07:48:41 GMT

Hi ,

Based on which filed I have to do the left join

Re: joining requirement, help required in set analysis

ashfaq_haseeb — Thu, 30 Oct 2014 07:50:54 GMT

LOCID

Which is key field

Re: joining requirement, help required in set analysis

alexandros17 — Thu, 30 Oct 2014 07:51:16 GMT

You can have the same result even if you do not perform the join.

Load both tables, you will have all values because tables will associate on common fields (similar to join)

Let me know