Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
How about this?
RangeSum(Above(Sum(Sales)/Sum(total Sales), 0, RowNo()))
Patrik.
the expression is a set analyisis expression:
sum({<Type={'X'}>}Sales)
Like this?
Yes, like this, but I don't habe the Modifier (accumulation) in Qlik Sense. Ist this in a newer Qlik Sense version?
Yes, try the latest one, i.e. - Nov 2019
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.
worked, thank both!
But how can I show the relative sum(Question 2)?
How about this?
RangeSum(Above(Sum(Sales)/Sum(total Sales), 0, RowNo()))
Patrik.
Worked,Thanks