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 |
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.
Thanks in advance.
