Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot Accumulate - 2 dimensions

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.

Clipboard01.jpg

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

Clipboard02.jpg

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

4 Replies
Not applicable

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

Contributor III
Contributor III

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

Not applicable

Hi,

Include subtotals. Look at the example.

Contributor III
Contributor III

Hi,

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

Clipboard03.jpg

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

br

Nils