Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

ABC marks by accumulation condition in table

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:

PremiumRevenueAmountDateMonthProduct
2005000506.01.20141Product6
2001000706.01.20141Product7
23515501507.01.20141Product4
2358000207.01.20141Product5
235300107.01.20141Product7
5507701501.01.20141Product9
155030001402.01.20141Product10
220010000106.01.20141Product9
253512150207.01.20141Product8

And I need this:

PremiumABC PremiumRevenueABC RevenueAmountABC AmountMonthProduct
235C1550C15B1Product4
550C770C16A1Product9
1550B3000C14B1Product10
200C1000C7C1Product7
200C5000C5C1Product6
2535A12150A2C1Product8
235C8000B2C1Product5
2200B10000B1C1Product9
235C300C1C1Product7

Have any ideas???

4 Replies
vgutkovsky
Honored Contributor II

Re: ABC marks by accumulation condition in table

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

jsaradhi
Valued Contributor

Re: ABC marks by accumulation condition in table

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

Not applicable

Re: Re: ABC marks by accumulation condition in table

For understand task try this:

Not applicable

Re: Re: ABC marks by accumulation condition in table

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

Community Browser