Qlikview 11.20: show product that generate 50% of the total sales

[paolojolly]

Hi, I need help to create a table chart that returns product(ARTICOLO) that generate x%(Percentage value indicated with slider SLIDER PERC) of the total sales(W_TOT_IMP_RIGA)
In attached document i have:
-in chart TAB1 items(ARTICOLO) sorted by sales (W_TOT_IMP_RIGA) with rank position
-in chart 2 i need to show for dimensions
D_MARCHIO_FLD
D_PRODOTTO_FLD
D_FAMIGLIA_FLD
the product(ARTICOLO) that generate x%(Percentage value indicated with slider SLIDER PERC) of the total sales(W_TOT_IMP_RIGA) with total sales for each dimension

In Qlikview 12 I can use as dimension
Aggr(

    If(Rangesum(Above(Sum({1} W_TOT_IMP_RIGA)/Sum({1} total W_TOT_IMP_RIGA),1,RowNo()))<vFirstX, ARTICOLO),

    (ARTICOLO,(=Sum({1} W_TOT_IMP_RIGA),Desc))

    )

instead of ARTICOLO dimension , but that doesn't work in Qlikview 11.20
in Qlikview 11.20 I tried to use dimension limit but doesn't work

Can someone help me?
Thanks

[sunny_talwar]

It is very difficult to do this (if not impossible)... take a look here

ABC Analysis in Qlikview