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
SALES Q* PRICE
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.
