Discussion Board for collaboration on QlikView Scripting.
Hi. Need experienced and wise adviser.
I have 3 indicators by date.
I have to mark each by letter by condition.
A: <= 20%*,
B: >20% and <=80%*
* - accumulation sum sorted by value
I have this:
And I need this:
Have any ideas???
Accumulating per product?
And what does the percentage indicate (what are you dividing)? Or does the percentage represent the accumulation per product to the total value of each metric per product?
something like attached? modify the expression for ABC Premium (i just used an example expression) and add other expressions for other ABC fields.
For understand task try this:
At first need to sort Products by *sum(Amount) and calculate sum(Amount) by Full Accumulation then looking for result marks ABC.