Pareto

[#1]

Hello,

I have a book of Wiley QLikview your business and it discusses the Pareto reports.

I am following the instructions.

It discribes of creating an expression sum(carssold).

then you have to clone this and check the relative box.

then you have to clone another one and check the relative and full accumulation box.

This last one doesn't work and also the sort on the last box doesn't work.

Anybody familiar with this problem?

The relative box works

The relative an full accumulation doesn't work

[#2]

I did some testing, I found Full accumulation working only if chart have only one dimension. Its not working if chart have more than one dimension.

[swuehl]

I usually try to avoid the accumulation options, instead I use something like

RangeSum(Above( YourExpression, 0, RowNo())

or for full accumulation

RangeSum(Above(TOTAL YourExpression, 0, RowNo(TOTAL))

For the relative option, I admit I also avoid often the chart option, but calculate it using  something like

Sum(Value) / Sum(TOTAL<Dim1, Dim2> Value)

where the TOTAL qualifier field list allows you to finetune the scope of the relative value.