Accumulation Issue with Multiple Dimensions

datagrrl — Fri, 27 Jan 2017 16:49:42 GMT

I am working with someone who wants to use accumulation on a bar chart with two dimensions.

The issues I seem to have is when there are not records for all of the values of both dimensions.

In the example below there are no values for 2015 for Yellow in the data. Since Yellow is the last value, it seems to have forgotten to accumulate the values for 2015, since Yellow has no values for that Year.

I can make this work if I set up expressions for each of the values for year instead of using two dimensions, but that really isn't the way we wanted to do it.

Is this expected behavior? If so, any explanation is welcome.

Re: Accumulation Issue with Multiple Dimensions

holmlund — Fri, 27 Jan 2017 18:03:45 GMT

ColorTest:

LOAD Test,

Year,

[Color Name],

Family,

Group,

Messy,

Total,

Utilized,

Hex,

Group2,

Look

FROM

[ColorsTestData.xlsx]

(ooxml, embedded labels);

YearFamily:

Load Year Resident ColorTest;

outer join

Load Family Resident ColorTest;

You would at least need one combination of each possible Year/Family combination.

And you also have to uncheck "Suppress zero values" from Presentation tab for your data to accumulate for all years.

topic Accumulation Issue with Multiple Dimensions in QlikView

Accumulation Issue with Multiple Dimensions

Re: Accumulation Issue with Multiple Dimensions