Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Kiran.