Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Have you tried to apply a TOTAL qualifier to the above and the rowno functions?
i tried TOTAL, i also tried aggr, none works, any other ways?
Try: rangesum(above(total sum(sales),0, rowno(total))).
You might also want to take a look at this document.
R u tried the simple expression sum(Sales)
and on right side tick on Full accumulation
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..