How to group a values in Dimension in Script and Chart level

[#1]

     Hi friends,I am confused to get exactly Group the certain Dimension.Please any one help on below problem:

I have a Dimension with

Line of Bussiness

Property

Common Property

E & E Risks

Need to Group 'Property' with 'Common Property' for Line of Business?

How to achieve in scrip level and also in Fron end Chart if i take Line of Bussiness as Dimension

[amit_saini]

Hi,

At the script side you can write:

Property &' -' &Common Property as Required_Fields

Also you can use this front end.

Thanks,
AS

[amit_saini]

Also try  something like this:

STATE_FIPS & '-' & COUNTY_FIPS

is for QV script, no for SQL.  In SQL, you can do this:

STATE_FIPS + '-' + COUNTY_FIPS

Thanks,
AS

[#4]

Not Working I have Dimension Line of Bussiness i need to group(Property+Common Property) as Combine Property.

Property

Common Property as Combine Property

E & E Risks

Final o/p:

Line of Bussiness	Before Grouping Dimension Line of Bussiness	After Grouping Dimension Line of Bussiness
Property	12	34
Common Property	22
E & E Risks	44	44
Total	78	78

[anbu1984]

Load LineOfBusiness,Sum(Num) As Num Group by LineOfBusiness;

Load If(LineOfBusiness='Common Property','Property',LineOfBusiness) As LineOfBusiness,Num Inline [

LineOfBusiness,Num

Property,12

Common Property,22

E & E Risks,44 ]

[Anonymous]

You need

Common Property + Property as Combine Property  ,   correct ?

ie. 22 + 12 = 33,

So you just need to mention this code

Load Property,
[Common Property], Common Property +Property as Combine Property

from table;

and use this field in your chart.

Thanks

BKC

[Anonymous]

'Common Property' and 'Property' are not the field names, they are the values of the field "Line of Business".  That is, the answer from anbu1984 is correct.