how to generate the bars in bar chart

[#1]

Hi,

i have some data like one dimension and one expression. in dimension column data is close, raclose1, finished, removed, close4, open,pending....etc use this data to develop bar chart. in the bar chart all close data means(close, raclose1, finished, removed, close4) combined to generate one bar and remaining two are two bars in bar chart is it possible. plz tell me any one urgent...     

[jagan]

Hi Subbu,

In script try like this

LOAD

*,

If(Match( ColumnName, 'close', 'raclose1', 'finished', 'removed', 'close4'), 'finshed',  ColumnName)

FROM DataSource;

Now use this new column as dimension, this is the best method instead of doing this in front end.

Regards,

Jagan.

[#3]

i m using the qvd data. so  change dimension in calculated  dimension  field  only. plz tell me dimension field caclulation......

[jagan]

Hi,

Even you use QVD you can do this

Data:

LOAD

*,

If(Match( ColumnName, 'close', 'raclose1', 'finished', 'removed', 'close4'), 'finshed',  ColumnName)

FROM Data.qvd;

If you want to do this in Calculated dimension then use this

If(Match( ColumnName, 'close', 'raclose1', 'finished', 'removed', 'close4'), 'finshed',  ColumnName)

Regards,

jagan.

[#5]

don't write the script level.i am apply only in calculated dimension field or expression  level in bar chart plz help in UI design format only. 

[jagan]

Hi,

Try this as calculated dimension in Dimension tab

If(Match( ColumnName, 'close', 'raclose1', 'finished', 'removed', 'close4'), 'finshed',  ColumnName)

Regards,

Jagan.