how to show sum of rows on the basis of total rows..

[kavita25]

Hi,

PFA.

Regards,

Kavita

[sunny_talwar]

What exactly are you counting here? This?

[kavita25]

The second column..

[sunny_talwar]

So the first 11 rows meet your definition of Total Gross Revenue's 20% is less than or equal to gross revenue. How are you counting 118 here? I mean the 11th row itself is 120

What am I missing her?

[kavita25]

20% is 13.6...

And we want those quantity whose gross revenue is 13.6 or less than 13.6..

So..

                                      GRevenue                   Quantity

MAHINDRA 265 DI S PS	0.2	4
MAHINDRA 415 DI PS CRPTO TRACTOR	1.1	15
MAHINDRA 265 DI S MECH	1.4	20
MAHINDRA YUVO 275 DI PS TRACTOR	2.6	39
MAHINDRA YUVO 415 DI PS TRACTOR	3.7	40

           Total                       9                  118

[sunny_talwar]

You made this whole lot more complicated now

There is not straight forward way to do this, but see if this links help:

ABC Analysis in Qlikview

[kavita25]

But i hope you understand my requirement  better now..

[sunny_talwar]

I absolutely do.... but this require me to accumulate in a text box object which is not very straight forward as I would like

[Gysbert_Wassenaar]

Can't be done really. Unless you precalculate stuff in the script and have QV 12 so you can use the sort feature of the aggr function. Or if you use actions that involve Pareto Select and messing about with alternate states.

[sunny_talwar]

Yup, I agree.... John and I came up with this two button strategy

ABC Analysis in Qlikview

[sunny_talwar]

Well I should not take credit for John's work here... John came up with this two button strategy