topic Re: Full accumulation with 2 dimensions in QlikView

Full accumulation with 2 dimensions

Thu, 06 Jun 2013 19:47:17 GMT

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.

swuehl — Thu, 06 Jun 2013 21:41:58 GMT

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

Mon, 10 Jun 2013 09:09:23 GMT

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

Thanks.

Gysbert_Wassenaar — Mon, 10 Jun 2013 09:11:48 GMT

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

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

er_mohit — Mon, 10 Jun 2013 09:12:35 GMT

R u tried the simple expression sum(Sales)

and on right side tick on Full accumulation

Mon, 10 Jun 2013 09:19:41 GMT

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..