Accumulative value issue

Mon, 17 Oct 2011 20:24:50 GMT

Hi,

I have a problem when I use an accumulative expression on a simple table. What im trying to dois something like this:

PRODUCT	SALES Q	PRICE	SALES Q * PRICE	TOTAL	% TOTAL SALES Q* PRICE	ACCUMULATED VALUE	CATEGORY
PRODUCT	SALES Q	PRICE	SALES Q * PRICE	SALES Q* PRICE	% TOTAL SALES Q* PRICE	ACCUMULATED VALUE	CATEGORY
C	20	10	200	420	48%	48%	A
B	30	3	90	420	21%	69%	B
D	8	10	80	420	19%	88%	B
A	50	1	50	420	12%	100%	B
			420		100%

The issue here is the expression to get the accumulated value:

- Expression:[% TOTAL SALESQ* PRICE]. If I use the qlikview function of accumulate in the properties of the object, when I evaluate the category in terms of accumulated value, the accumulated value is for example, in the B product, 21% instead of 69%. (All accumulated values below 50% should be category A).
- The other option is to use the following expression:

if (rowno() = 1, [% TOTAL SALESQ* PRICE], [% TOTAL SALES Q* PRICE] + above ([ACCUMULATED VALUE],1) .

With this expression the values may be ok, but the sort order that I need (order by % TOTAL SALES Q*PRICE desc) is no longer used for a reason that I don’t know.

I wonder is there is form of taking the literal value of a column or a way to force the sort order that I need.

I hope I was clear enough otherwise ill try to explain the problem better.

Thanks in advance.

topic Accumulative value issue in QlikView

Accumulative value issue