Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

assistance required in expression to show top rsultsin text object of chart ?

Hi there, 

Please kindly assist me with the expression , I want achieve the most "Episode Speciality on separation" shown as text at top of the chart, as you see there are two "Dental Surgery" and "Emergency Medicine" result thus my expression is not working.

Here is my expression - =FirstSortedValue(Concat(DISTINCT [Episode Specialty on Separation], ','), [Episode Specialty on Separation] ,-Aggr(Sum([ETP Numerator])/Sum([ETP Denominator]), [Episode Specialty on Separation]))

 

Please suggest.

req.PNG

 

Thanks in advance

1 Solution

Accepted Solutions
MayilVahanan

Hi


Try like below

=Concat(Distinct Aggr(if(Rank(Sum([ETP Numerator])/Sum([ETP Denominator]))=1, [Episode Specialty on Separation]), [Episode Specialty on Separation]), ',')

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

1 Reply
MayilVahanan

Hi


Try like below

=Concat(Distinct Aggr(if(Rank(Sum([ETP Numerator])/Sum([ETP Denominator]))=1, [Episode Specialty on Separation]), [Episode Specialty on Separation]), ',')

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post