topic Calculated Dimension Help in QlikView

Calculated Dimension Help

Tue, 24 Jul 2012 14:28:00 GMT

I wonder if calculated on a scale I can use sum or count values, because I want to group information by one dimension. Thank you.

Re: Calculated Dimension Help

Tue, 24 Jul 2012 14:58:11 GMT

There are many functions in qlikview to achieve your need. Aggr() function to group value for a dimension, TOTAL construct in expression for grouping by a dimension in a table etc..

Can you be more specific in your requirement?

Kiran Rokkam.

Re: Calculated Dimension Help

Tue, 24 Jul 2012 15:01:38 GMT

Do I need a calculated dimension to tell if the contents of a field is 1 or 0, but need to put in the second column to group by area dimension (first dimension)

Re: Calculated Dimension Help

Tue, 24 Jul 2012 15:07:26 GMT

In a chart group by will be evaluated for all available dimensions hence you need to add a calculated dimension. If the data needs multiple aggregations then aggr() function is needed. Aggr() function actually creates a table and then applies the computation.

Kiran.