topic Re: How to group a values in Dimension in Script and Chart level in QlikView

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

Fri, 03 Apr 2015 08:11:28 GMT

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

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

amit_saini — Fri, 03 Apr 2015 08:21:08 GMT

Hi,

At the script side you can write:

Property &' -' &Common Property as Required_Fields

Also you can use this front end.

Thanks,
AS

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

amit_saini — Fri, 03 Apr 2015 08:23:59 GMT

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

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

Fri, 03 Apr 2015 08:35:34 GMT

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	34
E & E Risks	44	44
Total	78	78

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

anbu1984 — Fri, 03 Apr 2015 11:10:16 GMT

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 ]

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

Anonymous — Fri, 03 Apr 2015 11:52:07 GMT

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

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

Anonymous — Fri, 03 Apr 2015 11:57:26 GMT

'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.