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

paolojolly — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Mon, 21 May 2018 11:58:00 GMT

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

ABC Analysis in Qlikview

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

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

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