Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
nilsgc
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

nilsgc
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.

nilsgc
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