Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension Help

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.

3 Replies
Not applicable
Author

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.

Not applicable
Author

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)

Not applicable
Author

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.