Some Qlik DataMarket data sets contain dimensions that include an aggregate field value. These dimensions represent hierarchies and contain more than one field, representing levels of that hierarchy. Fields within the hierarchy may contain blank values. The numbers associated with those blank values are aggregates of the numbers associated with the other values in that field.
In the example displayed in the image, the aggregate field value contains the total of both Female and Male.
The blank value field is included whenever all subset field values of a dimension are included. The totals associated to the aggregate field values are present in the data and can result in double-counting if they are including when calculating aggregates over data.
Depending on your visualizations used, you can exclude the aggregate field values. Fox example:
- Set the blank value to null using the Set nulls data profiling card in Data manager and exclude the null value from the dimension by clearing Include null values in the Dimension section of Properties.
- Use an expression to limit what dimension values are included and then clear Include null values in the Dimension section of Properties. For example, from the Sex dimension, you could use the expression =if(match(Sex,'Female','Male'),Sex) to exclude the aggregate field value.
- Use Set analysis expressions to exclude the blank value's aggregate numbers from a measure.
For more information, see Understanding and solving circular references.