display sum of largest 10 in "show title in chart" filed

[#1]

Hi,

i have a bar chart where i marked to show largest 10th in the dimensions limit.

i would like to show the sum of all the largest 10th in the "show title in chart" option.

i have tried to use Rank, but without any success.

can any one help?

BR,

Moti

[sunny_talwar]

Would you be able to share a sample to show what you mean?

[swuehl]

Maybe something like

=Sum({<DimensionField = {"=Rank(Sum(Amount))<=10"}>} Amount)

where Sum(Amount) is the expression used in the chart and DimensionField the field used as dimension.

[#4]

thanks, Stefan. it helped.

this is the advanced version from your assistant:

='Top <='&$(TOP)&': ' & num(Sum({<SKU = {"=Rank(Sum(if(BoxWeight>=$(SKU Weight),BoxWeight*PartialQty)))<=$(TOP)"}>} if(BoxWeight>=$(SKU Weight),BoxWeight*PartialQty)),'#,##0') & ' ('&num((Sum({<SKU = {"=Rank(Sum(if(BoxWeight>=$(SKU Weight),BoxWeight*PartialQty)))<=$(TOP)"}>} if(BoxWeight>=$(SKU Weight),BoxWeight*PartialQty)))/(sum({1<SKU>}  BoxWeight*PartialQty)),'#,##0%') & ')'

$(TOP) and $(SKU Weight) are variables changed by a slider.

moti

[swuehl]

Great, if your request is resolved, then please close this thread by marking helpful and / or corrent replies.

Qlik Community Tip: Marking Replies as Correct or Helpful