Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Rank() with not equal values

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

1 Reply
suvechha_b
Creator III
Creator III
Author

I tried this expression and it worked.

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