Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I tried this expression and it worked.
=if(aggr(rank(Sum({<SERVICE_TYPE =- {'Clinic','Doctor''s Rooms'}>}CLAIMS_PAID)),CLAIM_KEY )<=5,SERVICE_TYPE)