Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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

bcavestro
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