Ideal Model for Visualization Friendly

Anonymous — Fri, 24 Apr 2015 17:47:47 GMT

Hi folks...

At this time I would like to ask your opinion for the following situation...

I have compare the real situation vs plan previously created

DATA REAL:

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:

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

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

Re: Ideal Model for Visualization Friendly

Fri, 24 Apr 2015 18:19:27 GMT

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;

topic Re: Ideal Model for Visualization Friendly in QlikView

Ideal Model for Visualization Friendly

Re: Ideal Model for Visualization Friendly