Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Help with Excel data to QVD

Good Afternoon,

I've looked over the forums here for a while before posting so if I've missed a relevant discussion, I apologize.

Also when replying keep in mind I'm fairly new to creating QVD's.

I've got an excel document that I would really rather not change the format of to be able to work as a QVD.

So here's my question:

I've got a project in excel and to track it's related tasks I've numbered them 1, 1a, 1b, 1c, etc. The problem with this is that while my QVD does great, it doesn't know to relate 1 to 1a and so on. Is there a way to relate these in such a way that if I've got multiple projects with multiple numbers 1-9, with any number of letters associated with them, A-Z where I won't need to identify each relationship?

Here's a sample of what my excel template looks like.

Here is the beginning of my QVD:

Thank you in advance.

-Tim

Tags (1)
1 Reply
MVP
MVP

Re: Help with Excel data to QVD

1.jpg

tmp:

load * inline [

task, name

1a,analysis

1b,build

1c,test

1d,pilot

1e,deploy

1f,go live

2a,weekly reboot....

3a,total progress

4a,app doc

4b,server doc

4c,support

1,citrix

2,server reboots

3,file share

4,doc

];

task:

load

  if(IsNum(task), null(), PurgeChar(task, 'abcdefghi')) as parenttask,

  task,

  name

Resident tmp

where not IsNum(task);

Left join (task)

load task as parenttask, name as parenttaskname

Resident tmp

where IsNum(task);

DROP Table tmp;

Community Browser