Need Help in Line chart

[#1]

Dear Friends,

I am using one table as the column headers are like Month01, Month02, Month03, .....Month12, so I need to relate the months with auto generated months and then I need to create a line chart.

Can anyboday help me.

Regards

Chriss

[swuehl · Accepted solution]

What about loading your facts in a crosstable load, like

KPI:

Crosstable (KPMN#, Values, 4) LOAD  KPCORP,

    KPSUB,

    KPLOC,

    KPSCNAME,

    KPMN01,

    KPMN02,

    KPMN03,

    KPMN04,

    KPMN05,

    KPMN06,

    KPMN07,

    KPMN08,

    KPMN09,

    KPMN10,

    KPMN11,

    KPMN12,

    KPTOT;

SQL SELECT *

FROM S104F31D.KPIOUT;

And either creating a Month field directly in that created table or linking the KPMN# field to your first table:

test:

LOAD

    Monthname(today(),-(12-Right(F1, 2))) as MonthName,

    'KPMN'&right(F1,2) as KPMN#

Resident [input];

All untested, since you haven't provided a qvw file that we can reload (which is always a nice thing), e.g. by using INLINE LOAD data sources.

Regards,

Stefan

[#3]

Dear Stefan,

It works.....thanks for your help.

Regards

Chriss