Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Singaravelu_R
Contributor III
Contributor III

How to show Max of Length of text in Table

Hi Team,

I am very new to Qlik Sense and I already have good experience in Power BI.  My requirement is I have employee Name, Employee location, Employee Designation in my slicer. if I select any slicer or all slicer (one value of multiple value) I want to show Max length of selected value Text number in my bar chart.

Example: Assume  , are selected value of slicer. So based on my current selection my Bar chart would show the value of 6 as of Max length of selected slicer value is Carref = length of character is 6. Please give your suggestion how can we achieve this. Thanks for you help.

Employee NameEmployee locationDesignation
x,kar ,xxx
y ,bard ,yyy
z ,carref ,zzz
 ff 
Labels (1)
1 Reply
PradeepK
Creator II
Creator II

for table 

 

Max(Len(<Field>))

 

for title/text/variable :

 

Max(
	Aggr(
      len(<Field>)
      ,<Aggr Dim list>
   )
)