So you have two separate tables which are not linked to each other and you don't want them to concatenate? Even you don't want field name to be changed?
Create calendar table which should have both manpower month and hire plan month to link both table and common calendar month to display in dimension of the chart.
Thank you so much for your prompt response.
I should not change or concatenate the field name, because the field names are also being used by other graphs ( >15).
I can create calendar table within "excel I" file but not "excel ii," because it is directly coming from an SQL server source that I can never touch or edit. Is there any other way?
What if I add a field name "SERVICE_START_DATE" in excel i and give the same value of "Month"? Would that possibly link them?
You don't have to create calendar in two separate table. Just create calendar table based on variable (see below), add two fields which can link to both tables and add common monthyear field which can be used in graph dimension.
LET vMIN_CALDATE = Num(MakeDate(2008,1,1));
LET vMAX_CALDATE = Num(MakeDate(2030,12,31));
Cal_DATE as ManpowerMonth,
Cal_DATE as HirePlanMonth,
MonthName(Cal_DATE) as MonthYear
LOAD Date($(vMIN_CALDATE) + RowNo() - 1) as Cal_DATE
AutoGenerate 1 While $(vMIN_CALDATE)+IterNo()-1<= $(vMAX_CALDATE);
If you are still facing any issue, provide sample apps with scrambled data to look into.
Thank you for your help.
I have attached some sample files that I made based on similar situation.
"excel i" is what you can make some changes such as adding new field, except chaning the current names.
"excel ii" - please assume this file as SQL data coming from server. I can't do any change to this file.
"Test" is a qlikview file that includes dimensions and expressions that I am using.
I tried what you suggested me but it did not work properly.
Could you please show me how you would solve this problem?
Thank you again.
*The end reslut graph does not need to show after today's date.*