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: 
venkat1
Creator II
Creator II

How to show top names with same percentages in text box

CAUSEDESCRIPTIONCLAIMNO
Insured 1177
Insured 2177
Insured 3177
Insured 478
Insured 545


How to display Insured1,insured2,insured3 in a text box.
Getting blanks for me after using below expression.

=fisrtsortedvalue(CAUSEDESCRIPTION,-aggr(sum(CLAIMNO),CAUSEDESCRIPTION))

 

1 Reply
MayilVahanan

Hi @venkat1 

Try like below

Create a variable "vTopInsurance" and assign the formula like below

=Concat(DISTINCT CAUSEDESCRIPTION, '|',-Aggr(Sum(CLAIMNO),CAUSEDESCRIPTION))

and use the below expression in textbox

TextBox1: =SubField(vTopInsurance,'|',1)

TextBox2:=SubField(vTopInsurance,'|',2)

TextBox3:=SubField(vTopInsurance,'|',3)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.