Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

adiarnon
Contributor III

how to save my data

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

3 Replies

Re: how to save my data

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.

Not applicable

Re: how to save my data

Could you please attach an example?

pokassov
Valued Contributor

Re: how to save my data

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