Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
kaveri_bhar123
Contributor II
Contributor II

Top, Next and Rest computation

Hi All,

I have a requirement where when we select particular "Company"  and "Speciality", we need to compute "Top 33 % of the doctor belonging to multiple company of that speciality". Similarily, we will compute "Next 33% of the doctor belonging to multiple of the company" and "Rest 33% of the doctor belonging to multiple of the company".

Best regards,

Kaveri

2 Replies
galax_allu
Specialist
Specialist

Hi

You can use Guage chart for this ..

or

some formula like below in PIEchart ...

=if(Aggr(Rank(count(doctor)), Company,Speciality)<=3, 'Top 3 ', 'Others')




boopeshj
Partner
Partner

Hi Kaveri

Can you please add more details to help you

-Boo