Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
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
upaliwije
Creator II
Creator II
Author

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

tresesco
MVP
MVP

Could you share your sample app?

upaliwije
Creator II
Creator II
Author

I attach h/w my sample data

bc-thebruuu
Creator
Creator

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

lanlizgu
Creator III
Creator III

What selections are you doing?

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

ASFD.JPG

lanlizgu
Creator III
Creator III

As Bruno mentioned PRL_PTY_CODE doesn't exists but PRL_CODE