Aggregation with fractile value

[menta]

Hi all,

I have a question for you. I would like to create a listbox that aggregates the number of Card_id that meet a condition.

I created a list box that Lists all the card in this way

Expr: If(Value<=Fractile(TOTAL Value,0.1),Card_id )

I would like to create a list box that give me the number of these cards and help me to select these cards.

Can anyone help me?

[#2]

Not sure if this is what you mean:

In list box properties, under the general tab, select the option "Show Frequency". This will indicate how many Card_Ids fall under a given fractile.

[menta]

Thank you but is not my request

[tresesco]

I guess, it would to be with Aggr(), like:

=Aggr(If(Value<=Fractile(TOTAL Value,0.1),Card_id ) , Card_id)        // total keyword might not be required

[menta]

I already have this listbox, I need a list box that show me the fractile number, for example 0.1 and on clik on this number I automatically select all the cards. I need and aggregation of this aggregation.

[tresesco]

Please post your sample qvw.

[menta]

I don't know the way to attach a file