topic Pareto in QlikView

Pareto

Fri, 30 Oct 2015 18:57:50 GMT

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

Sat, 31 Oct 2015 01:30:49 GMT

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 — Sat, 31 Oct 2015 12:26:25 GMT

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.