Sort cumulative sales by Advisor

[madmax88]

Hi,

Is it possible to get a bar chart with the cumulative sum by advisor? Highest Sales first.

E.g.

Advisor 1	10
Advisor 2	15
Advisor 3	1
Advisor 4	5
Advisor 5	20
Advisor 6	50
Advisor 7	0
Advisor 8	-5

Result (in a bar chart)

Advisor 6	50
Advisor 5	70
Advisor 2	85
Advisor 1	95
Advisor 4	100
Advisor 3	101
Advisor 7	101
Advisor 8	96

And 2nd. Question: Is it also possible to show the cumulative sum in percentage?

((B5/Sum(B$4:B$11))+D4)

(B6/SUMME(B$4:B$11))+D5

etc.

Advisor 6 52% (D4)
Advisor 5 73% (D5)
Advisor 2 89% (D6)
Advisor 1 99% (D7)
Advisor 4 104% (D8)
Advisor 3 105% (D9)
Advisor 7 105% (D10)
Advisor 8 100% (D11)

[madmax88]

the expression is a set analyisis expression:

sum({<Type={'X'}>}Sales)

[tresesco]

Like this?

[madmax88]

Yes, like this, but I don't habe the Modifier (accumulation) in Qlik Sense. Ist this in a newer Qlik Sense version?

[tresesco]

Yes, try the latest one, i.e. - Nov 2019

[Patrik_Lundblad]

Hi,

Yes that's from the November 2019 release, but the good part is that we do have an "output expression" box where you can copy paste the expression used for accumulation. 

So given that you make the sorting change as shown above then paste this as your measure (replace the Sum(Sales) with your set expression)

RangeSum(Above(Sum(Sales), 0, RowNo()))

Not sure how to do the cumulative percentage.

Regards,

Patrik.

[madmax88]

worked, thank both!

But how can I show the relative sum(Question 2)?

[Patrik_Lundblad · Accepted solution]

How about this?

RangeSum(Above(Sum(Sales)/Sum(total Sales), 0, RowNo()))

Patrik.

[madmax88]

Worked,Thanks