topic Re: Cumulated Value in QlikView

Cumulated Value

Anonymous — Tue, 17 Jan 2017 16:34:07 GMT

Hi to all,

I would like to ask how to solve this issue. In the first graph there is a normal Pareto Chart with cumulated line (percentage value).

In the second one i would like to create the same graph but with the indication only in the tooltip (label calculated field). I tried to calc the cumulated % value but I did not succeed. Anyone can help me?

Thank in advanced.

Andrea

Re: Cumulated Value

sunny_talwar — Tue, 17 Jan 2017 16:45:30 GMT

Do you have QV12? If you do, this can work

= 'Name: ' & Name & chr(10) &

'Purchased (€): ' & num(Purchased,'€ #.###,') & chr(10) &

'Purchased % Cumulated: ' & Num(Aggr(RangeSum(Above(Sum(Purchased), 0, RowNo()))/Sum(TOTAL Purchased), (Purchased, (NUMERIC, DESC))), '##,0%')

Also, you want to this pareto by just Purchased or Sum(Purchased)? It seems that the order of client might change if you do Sum(Purchased)

Re: Cumulated Value

Anonymous — Tue, 17 Jan 2017 16:51:07 GMT

Thank you so much Sunny.

In the database there is only one row for each Client so is it different use Sum or it maybe changes something?

Re: Cumulated Value

sunny_talwar — Tue, 17 Jan 2017 16:53:53 GMT

Not sure what was causing it before, but it seems that it has been resolved now

Re: Cumulated Value

Anonymous — Tue, 17 Jan 2017 16:59:01 GMT

Goood i would like to ask to you some clarification about this sentence that you used in the previous calc:

(Purchased, (NUMERIC, DESC))

This is used in order to complete the AGGR function? how is this work?

Re: Cumulated Value

sunny_talwar — Tue, 17 Jan 2017 17:04:26 GMT

See here:

The sortable Aggr function is finally here!