topic Aggregation with fractile value in QlikView

Aggregation with fractile value

menta — Fri, 30 May 2014 13:51:55 GMT

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?

Re: Aggregation with fractile value

Fri, 30 May 2014 13:56:05 GMT

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.

Re: Aggregation with fractile value

menta — Tue, 03 Jun 2014 09:39:44 GMT

Thank you but is not my request

Re: Aggregation with fractile value

tresB — Tue, 03 Jun 2014 09:50:29 GMT

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

Re: Aggregation with fractile value

menta — Tue, 03 Jun 2014 10:27:10 GMT

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.

Re: Aggregation with fractile value

tresB — Tue, 03 Jun 2014 10:30:40 GMT

Please post your sample qvw.

Re: Aggregation with fractile value

menta — Tue, 03 Jun 2014 11:15:45 GMT

I don't know the way to attach a file