topic Re: Top, Next and Rest computation in QlikView

Top, Next and Rest computation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Top, Next and Rest computation

Anonymous — Fri, 05 Aug 2016 08:46:47 GMT

You can use Guage chart for this ..

some formula like below in PIEchart ...

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

Re: Top, Next and Rest computation

boopeshj — Fri, 05 Aug 2016 09:20:23 GMT

Hi Kaveri

Can you please add more details to help you

-Boo