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