Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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
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
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