Rank() with not equal values

[suvechha_b]

Hi All ,

How to write in qliksense set analysis expression with rank() . where SERVICE_TYPE is not equals to 'Clinic' and 'Doctor's Rooms'

=if(aggr(rank(Sum({<SERVICE_TYPE <> {'Clinic'}>}CLAIMS_PAID)),CLAIM_KEY )<=5,SERVICE_TYPE)

Please kindly assist me in writting the set analysis expression.

Regards,

Suvechha

[suvechha_b]

I tried this expression and it worked.

=if(aggr(rank(Sum({<SERVICE_TYPE =- {'Clinic','Doctor''s Rooms'}>}CLAIMS_PAID)),CLAIM_KEY )<=5,SERVICE_TYPE)