Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

arthuriuxx
New Contributor

Ideal Model for Visualization Friendly

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_REALNAMEDATE_STARTDATE_ENDID_LINK

01       

TASK 115/01/201531/01/201501
02         TASK 215/01/2015   15/02/201502
03TASK 301/02/201528/02/201503
04TASK 401/05/201520/05/201504
05TASK 501/03/201531/03/2015--
06TASK 601/04/201515/04/2015--

DATA PLAN:

ID_PLANNAMEDATE_STARTDATE_END

01       

TASK 101/01/201531/01/2015
02         TASK 201/01/2015   31/01/2015
03TASK 301/02/201528/02/2015
04TASK 401/02/201531/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

Tags (3)
1 Reply
Not applicable

Re: Ideal Model for Visualization Friendly

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;


Community Browser