Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Full accumulation with 2 dimensions

Hi,

Im creating a bar chart, with Month/Year and Sales status in dimension.

In expression, i'd do rangesum(above(sum(sales),0, row()))

it works without Sales status, how can i make it work with second dimension?

Thanks.

5 Replies
MVP
MVP

Re: Full accumulation with 2 dimensions

Have you tried to apply a TOTAL qualifier to the above and the rowno functions?

Not applicable

Re: Full accumulation with 2 dimensions

i tried TOTAL, i also tried aggr,  none works, any other ways?

Thanks.

Re: Full accumulation with 2 dimensions

Try: rangesum(above(total sum(sales),0, rowno(total))).

You might also want to take a look at this document.


talk is cheap, supply exceeds demand
er_mohit
Honored Contributor II

Re: Full accumulation with 2 dimensions

R u tried the simple expression sum(Sales)

and on right side tick on Full accumulation

Not applicable

Re: Full accumulation with 2 dimensions

yes, i tried, it works, the problem now is to add 2nd dimension in stacked bar, together in acculation mode, it doesnt work.

Hi Gysbert, i think the total are summing all, and the chart is not in ascending style..

Community Browser