topic Re: how to save my data in QlikView

how to save my data

adiarnon — Mon, 30 Mar 2015 11:03:12 GMT

hi,

I need to model data from MS project.

I have a problem - how to save the data of the dependencies between tasks.

I have a table-

PREV TASK

CURRENT TASK

i need that if im selecting one of ny tasks i wiil see-

1. all the tasks that must be before

2. all the tasks that this task is "pushing"

how should i save my data?

adi

Re: how to save my data

avinashelite — Mon, 30 Mar 2015 11:50:15 GMT

Hi adi,

I don't know how your data is organised in the DB .

if you have all the details in a single table then its very easy, just pull the data and store it an QVD so that it will have the previous and next task as columns. If not make it as 3 different tables i.e the previous task details, next task details with the primary key for it .

Hope this helps you.

Re: how to save my data

Mon, 30 Mar 2015 12:02:42 GMT

Could you please attach an example?

Re: how to save my data

pokassov — Mon, 30 Mar 2015 12:41:10 GMT

Hi Adi!

I think you should see Hierarchy and HierarchyBelongsTo

//example data

t1:

LOAD * Inline [

NodeID, ParentID, NodeName, TimeLength

1,, Task 1, 10

2,1, Task 1.1, 12

3,1, Task 1.2, 2

4, 2, Task 1.1.1, 4

5, 4, Task 1.1.1.1, 5

];

//for your first question:

//field NodeName is your selected task

// field ParentName are its previos tasks

t2:

HierarchyBelongsTo (NodeID, ParentID, NodeName, Tree, ParentName) LOAD

NodeID,

ParentID,

NodeName

Resident

t1;

DROP Table t1;

//for your second question:

// you can

//t2:

//Hierarchy(NodeID, ParentID, NodeName,ParentName,NodeName, Task, '/') LOAD

//NodeID,

//ParentID,

//NodeName,

//TimeLength

//Resident

// t1;

Btw, I don't now how to use both ways for your model