topic List box expression in QlikView

List box expression

upaliwije — Wed, 25 Apr 2018 04:15:58 GMT

Hi Firiends

I have created a expression to limit Ailments to 10 in my list box and other ailments to be shown as OTHERS. How ever it does show only 9 ailments and OTHRES do not apper at all. Pls chcek my below expression and corret my expression.

=aggr(If(Rank(SUM({<CLA_CODE={'SS'},PRL_PTY_CODE={'INP'},ALM_CODE-={"C152","NMT"}>}LBP_CLAIMS_PAID))<=10,ALM_DESC,'OTHERS'),ALM_DESC)

Thanks

Re: List box expression

upaliwije — Wed, 25 Apr 2018 06:26:00 GMT

Can someone please help me ? If you need further information pls contact me please

Re: List box expression

tresB — Wed, 25 Apr 2018 06:27:02 GMT

Could you share your sample app?

Re: List box expression

upaliwije — Wed, 25 Apr 2018 07:14:19 GMT

I attach h/w my sample data

Re: List box expression

bc-thebruuu — Wed, 25 Apr 2018 07:32:19 GMT

In the application you provided, the field PRL_PTY_CODE doesn't exists

So ... is smthing like that what you are looking for?

=If(Aggr(Rank(TOTAL SUM({<CLA_CODE={'SS'},ALM_CODE-={"C152","NMT"}>}LBP_CLAIMS_PAID)),ALM_DESC)<=10,ALM_DESC,'OTHERS')

Re: List box expression

lanlizgu — Wed, 25 Apr 2018 07:57:25 GMT

What selections are you doing?

I did a binary to your document using the formula and I see correctly the list box.

Re: List box expression

lanlizgu — Wed, 25 Apr 2018 07:58:48 GMT

As Bruno mentioned PRL_PTY_CODE doesn't exists but PRL_CODE