Data Layout

[#1]

Hello,

I'm working on cleaning up data and laying it out in the best possible format for qlikview and hit sort of a roadblock. Looking for clarification on how to best handle this kind of information. Here's an example

Date	Fulltime	Part-time	Contractor
01/01/2014	10	5	2
01/08/2014	5	2	0
01/15/2014	10	1	2

Now the twist to this data set that makes this a bit more complicated is this data is for only one project. I need this information for 3 other projects and what i'm doing is trying to create a single line chart with other list boxes that can help narrow in on a single project. Any feedback would be greatly appreciated. Thanks in advance.

Cheers,

Ahmad

[MK_QSL]

Provide your qvw !

[#3]

uploaded, thank you. please note i actually only started with 2 of the tables just to see it work.

[MK_QSL]

You haven't used my full code....

[#5]

sorry, which part haven't i used? scroll to the bottom it's all there, no?

[MK_QSL]

You used only below

NEXT

CrossTable(Type, Data)

Load * Resident Test;

Drop Table Test;

NEXT if starting with FOR loop

FOR Each.....

CODE.

....

...

NEXT

[#7]

Ahhh I see, so the

NEXT

CrossTable(Type, Data)

Load * Resident Test;

Drop Table Test;

goes after ever table load. Okay sounds good. But now I'm getting a "Script Error":

Script Line Error:

NEXT

Would you like to see qvw?

[MK_QSL]

Sure

[#9]

uploaded

[#10]

any idea what i did incorrectly?

[#11]

Still looking for a solution to this, if anyone can shed some light I'd greatly appreciate it,