Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

List box expression

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

Screenshot_1.png

6 Replies
Highlighted
Creator II
Creator II

Re: List box expression

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

Highlighted
MVP
MVP

Re: List box expression

Could you share your sample app?

Highlighted
Creator II
Creator II

Re: List box expression

I attach h/w my sample data

Highlighted
Creator
Creator

Re: List box expression

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')

Highlighted
Creator III
Creator III

Re: List box expression

What selections are you doing?

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

ASFD.JPG

Highlighted
Creator III
Creator III

Re: List box expression

As Bruno mentioned PRL_PTY_CODE doesn't exists but PRL_CODE