topic ABC marks by accumulation condition in table in QlikView

ABC marks by accumulation condition in table

Wed, 02 Jul 2014 09:01:54 GMT

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%*

C: >80%*

* - accumulation sum sorted by value

I have this:

Premium	Revenue	Amount	Date	Month	Product
200	5000	5	06.01.2014	1	Product6
200	1000	7	06.01.2014	1	Product7
235	1550	15	07.01.2014	1	Product4
235	8000	2	07.01.2014	1	Product5
235	300	1	07.01.2014	1	Product7
550	770	15	01.01.2014	1	Product9
1550	3000	14	02.01.2014	1	Product10
2200	10000	1	06.01.2014	1	Product9
2535	12150	2	07.01.2014	1	Product8

And I need this:

Premium	ABC Premium	Revenue	ABC Revenue	Amount	ABC Amount	Month	Product
235	C	1550	C	15	B	1	Product4
550	C	770	C	16	A	1	Product9
1550	B	3000	C	14	B	1	Product10
200	C	1000	C	7	C	1	Product7
200	C	5000	C	5	C	1	Product6
2535	A	12150	A	2	C	1	Product8
235	C	8000	B	2	C	1	Product5
2200	B	10000	B	1	C	1	Product9
235	C	300	C	1	C	1	Product7

Have any ideas???

Re: ABC marks by accumulation condition in table

vgutkovsky — Wed, 02 Jul 2014 18:19:54 GMT

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?

Vlad

Re: ABC marks by accumulation condition in table

Anonymous — Wed, 02 Jul 2014 19:30:25 GMT

something like attached? modify the expression for ABC Premium (i just used an example expression) and add other expressions for other ABC fields.

Re: Re: ABC marks by accumulation condition in table

Mon, 07 Jul 2014 07:30:03 GMT

For understand task try this:

Re: Re: ABC marks by accumulation condition in table

Mon, 07 Jul 2014 07:39:14 GMT

At first need to sort Products by *sum(Amount) and calculate sum(Amount) by Full Accumulation then looking for result marks ABC.