topic Re: Different Field Names -Same content - Cannot Concatenate them in QlikView

Different Field Names -Same content - Cannot Concatenate them

helen_pip — Mon, 07 Apr 2014 12:14:22 GMT

Hello

I have a field called CWT_Monthly.Desc from 1 table

I have a 2nd field called CWT_Monthly_desc.desc_2 from another table

Both fields contain the exact same content, but are required to be called different names for other reasons

My problem is though although the fields need to remain being called diferent names, when I concatenate the 2 tables together to form 1 fact table the front end does not work properly

I have attached an example for you to look at. If you were to click on a selection from the "Description" list box the "Monthly Data" table at the top of the top of the page stops working

I ideally want to have 1 fact table for streamlining purposes, but do not know how to get around the fact that by having a concatenated table, the table stops showing it's data

Can anyone help me on this one please?

Kind Regards

Helen

Re: Different Field Names -Same content - Cannot Concatenate them

ariel_klien — Mon, 07 Apr 2014 12:28:33 GMT

Hi,

try to do this:

main_data:

LOAD CWT_Monthly_desc.desc_month_Year,

desc_percentage,

CWT_Monthly_desc.desc_2,

CWT_Monthly_desc.Desc_within_time,

CWT_Monthly_desc.Desc_total

FROM

C:\QLIKVIEW\DEVELOPMENT\HP\QVD\2014\CWTMONTHLYDESCQVD_2014_QLIK.qvd

(qvd);

Concatenate(main_data)

LOAD [CWT_Monthly.Month/Year],

Percentage,

CWT_Monthly.Desc,

CWT_Monthly.Desc as CWT_Monthly_desc.desc_2,

[CWT_Monthly.Within Time],

[CWT_Monthly.Total Seen],

CWT_Monthly.Target

FROM

C:\QLIKVIEW\DEVELOPMENT\HP\QVD\2014\CWTMONTHLYQVD_2014_QLIK.qvd

(qvd);

Re: Different Field Names -Same content - Cannot Concatenate them

nizamsha — Mon, 07 Apr 2014 12:31:28 GMT

To make it simple

table!:

CWT_Monthly.Desc from Table1;

Left Join

Table2:

CWT_Monthly_desc.desc_2 as CWT_Monthly.Desc,

CWT_Monthly_desc.desc_2

From Table2;

or please provide sme excel file

Re: Different Field Names -Same content - Cannot Concatenate them

helen_pip — Mon, 07 Apr 2014 12:38:48 GMT

Hello

I see what you are saying, but what I ideally need is for the "monthly Data" table to remain showing all data so that it does not then filter on just my selection from the description table

(I should have mentioned this 1st time round)

Thanks

Helen

Re: Different Field Names -Same content - Cannot Concatenate them

helen_pip — Mon, 07 Apr 2014 12:42:30 GMT

Hello

I see what you are saying, but what I ideally need is for the "monthly Data" table to remain showing all data so that it does not then filter on just my selection from the description table

(I should have mentioned this 1st time round)

Thanks

Helen