Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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.