Discussion Board for collaboration on QlikView Scripting.
At this time I would like to ask your opinion for the following situation...
I have compare the real situation vs plan previously created
I need compare this data, but need resolve first the selectors (type:date) in the application...
for example, if i compare in graphs for month, how much tasks have planned starting? and how much really started? and how much task are in process, how much task are terminated for month...
if i do with date Start in graph the data show correctly if i want see the number of task are started for month,
if i do with date End in graph the data show correctly if i want see the number of task are finished for month,
but i need available 2 selectors (DATE END and START) ans two graphs
how could be only one selector and one graph?
actually i tried make a master calendar with MIN(date start) and MAX(data_end) and join the data REAL with data PLAN in one table...
i need help or any advice for make my model ??
thanks in advance
I would concatenate into a single table, with a field to identify "real" vs "plan":
Data_Real_Temp: LOAD * INLINE [ ID_REAL, NAME, DATE_START, DATE_END, ID_LINK 01, TASK 1, 15/01/2015, 31/01/2015, 01 02, TASK 2, 15/01/2015, 15/02/2015, 02 03, TASK 3, 01/02/2015, 28/02/2015, 03 04, TASK 4, 01/05/2015, 20/05/2015, 04 05, TASK 5, 01/03/2015, 31/03/2015, -- 06, TASK 6, 01/04/2015, 15/04/2015, -- ]; Data_Plan_Temp: LOAD * INLINE [ ID_PLAN, NAME, DATE_START, DATE_END, 01, TASK 1, 01/01/2015, 31/01/2015, 02, TASK 2, 01/01/2015, 31/01/2015, 03, TASK 3, 01/02/2015, 28/02/2015, 04, TASK 4, 01/02/2015, 31/03/2015 ]; Data: LOAD ID_REAL AS ID, NAME, DATE_START, DATE_END, 'Real' AS FactType Resident Data_Real_Temp; Concatenate LOAD ID_PLAN AS ID, NAME, DATE_START, DATE_END, 'Plan' AS FactType Resident Data_Plan_Temp; DROP TABLES Data_Real_Temp,Data_Plan_Temp;