topic Re: Pivot Accumulate - 2 dimensions in QlikView

Pivot Accumulate - 2 dimensions

Anonymous — Mon, 15 Apr 2013 10:02:56 GMT

Hi All,

I've got a problem showing accumlates sales in a Pivot-chart. I've looked at all the other questions in this forum regarding similar problems, but not found a solution.

The accumulation works fine if I have colapsed all.

If I expand any of the CustomerGroups, the "Accumulated Sales" goes wrong

Expression for "Accumulated Sales"

Rangesum(sum(Sales) / sum(Total Sales), Above([Accumulated Sales]))

Any ideas? I've attached a qvw showing the problem

Best regards

Nils

Re: Pivot Accumulate - 2 dimensions

Mon, 15 Apr 2013 17:29:37 GMT

Hi,

There is no problem. When you expand the table, it shows the cumulative line by line. Did you, for instance, to produce 45% for the two lines Group Two?

Rebeca

Re: Pivot Accumulate - 2 dimensions

Anonymous — Mon, 15 Apr 2013 18:29:07 GMT

Hi,

Thanks for your reply.

But, there is a problem... the column "Accumulated Sales" should always give 100% at the last row. This is the case when all is colapsed - but as soon as one row is expanded the "Accumulated" goes wrong

Best regards

Nils

Re: Pivot Accumulate - 2 dimensions

Mon, 15 Apr 2013 19:54:54 GMT

Hi,

Include subtotals. Look at the example.

Re: Pivot Accumulate - 2 dimensions

Anonymous — Tue, 16 Apr 2013 12:11:57 GMT

Hi,

The SubTotals helped somwhat, but I would like to have this outcome :

I created the data for "Created Acc..."

Nils