QlikView App Dev

[#1]

i have a column name that includes the Phase and year (14Construction) and the data is $$$ value. How do i slit the phase which is construction and the year?

Example:

14Construction          15Designed

$$$                              $$$

$$                                   $

[jonathandienst]

Hi

In your load script:

LOAD Left(YrPhase, 2) & 2000 As Year,

     Mid(YrPhase, 3, 50) As Phase,

     ...

Hope that helps

Jonathan

[#3]

on top is what i have (and there are multiple column with different years and phases)  and on the bottom is what I'm trying to accomplish.

Phase	Years	Totals
Planning RO	14	$136,000
Planning AO	14	14,000
Design RO	13	2,000
Design AO	13	1,000
….	14	200,000
…	14	…
…	16	…
Planning RO	15	…
Planning AO	15	…

[jonathandienst]

I see the field names contain the year and phase information.

You might need a crosstable load to get this data into a more manageable fact style table. Check out crosstable loads in the manual. If you need more help on the crosstable, I suggest that you post some sample data here. The attach file option is available if you click on "Use advanced editor" on the reply window.

Jonathan

[#5]

this is only good for excel for example and not when connecting directly to the database. i want to do a crosstable in the script that already pull if is possible. my source is not Table Files, is ODBC.