This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have 3 tables. Sales, Forecast_Sales,Actual_Sales.
Forecast_Sales,Actual_Sales data is in crosstab table on YearMonth Level.
Sales data is in normal table and data is in Date Level.
I want to join/concatenate into one table to resolve the data model issue.
Could you please advise me in combining these 3 into 1.
Thanks in advance.
Not sure if this is what you want:
[Data - Copy.xlsx]
(ooxml, embedded labels, table is Sales);
CrossTable(YearMonth, ActualSalesData, 2)
(ooxml, embedded labels, table is Actual);
CrossTable(YearMonth, ForecastSalesData, 2)
(ooxml, embedded labels, table is Forecast);
LOAD MonthName(Date#(YearMonth, 'YYYY-MM')) as MonthYear,
MonthName(Date) as MonthYear,
DROP Tables Table1, Table2, Table3;
Data in Table Box:
Chart you were looking for:
Attaching the QlikView document for reference.
I hope this will help.
View solution in original post
What is this data on the actual tab without headers?
And secondly I know you mentioned that you want to join/concatenate the data, but do you have an idea of how you want to see the combined table to look like (expected output)?
Please ignore the unrelated data.
I want to see the data as below:
Hi Friend ,
I have modified your code , you can optimize more , i have done quickly .
Your Current data model is like
I think you want this ?
Attached your file.