Value Columns - SPC chart

[Former Member]

Hi,

i want to pass / set value columns at run time in SPC chart. i know the value column only at run time. i created one query template with giving table name and select query like select [param.1],date1 form temp1. i set attribute column of data mapping as date1. Say temp1 contains columns like Faran, temperature. i will choose any one of these column from front end. and i want to set that column name in value columns of data mapping. i tried with

document.<my applet>.getChartObject().setValueColumns("temperature"). but it displayed error as object doesnt support this property.

how to do it?

-senthil

[Former Member]

Senthil

First get the desired column name from the Query Template which gives the column names (eg Faren, Temp etc).

say that QT name - QTTemp which is saved in some defined folder in ur system.

then

Use following

1. document.<AppletForQTTemp>.getQueryObject().setParam(1,"?"); where "?" is the input param to be passed to that QT

2. document.<AppletForQTTemp>.executeCommand();

3. document.<AppletForSPCChart>.getChartObject().setValueColumns(document.<AppletForQTTemp>.getColumnName("?")); where "?" is the column number of the desired column u want to set.

Regards

Som

[Former Member]

hi senthil ,

have u updated the chart after setting the value column dynamically.

document.iChart.updateChart(true);

Regards,

Gurunadh.

[Former Member]

Hi,

S. Already i upadted it. but no result.

-senthil