Need Help in Line chart

Wed, 04 Jul 2012 10:26:21 GMT

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

Re: Need Help in Line chart

swuehl — Wed, 04 Jul 2012 10:42:52 GMT

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

Re: Need Help in Line chart

Wed, 04 Jul 2012 12:12:26 GMT

Dear Stefan,

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

Regards

Chriss

topic Re: Need Help in Line chart in QlikView

Need Help in Line chart

Re: Need Help in Line chart

Re: Need Help in Line chart