topic Aggregate Dimension Values in QlikView

Aggregate Dimension Values

malimohammed — Tue, 08 Jul 2014 08:33:33 GMT

We are to show the aggregation of Product Levels in the following way

Product Level is a dimension and has two values: 030 and 040. We are to show the Rows in a straight / pivot chart as follows:

Row 1 - 030 – sum of sales(of 030)

Row 2 – 030 and 040 – sum of sales(of 030 and 040 combined)

Is there an easy way to combine dimension values? Should we make a resident table and then sum the values? This is flexible we just have to show whether we are able to perform something like this? Combination of two different values.

Will really appreciate your assistance on this.

Re: Aggregate Dimension Values

MK_QSL — Tue, 08 Jul 2014 08:39:57 GMT

Consider that you have below table

Load * Inline

[

Customer, Product Levels, Value

A, 030, 100

A, 040, 120

B, 030, 200

B, 040, 220

];

Create a straight table

Dimension

Customer

Product Levels

Expression

IF([Product Levels] = '030',SUM({<[Product Levels] = {'030'}>}Value),

IF([Product Levels] = '040',SUM(TOTAL < Customer> Value)))