Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Singaravelu_R
Contributor II
Contributor II

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 
1 Reply
PradeepK
Creator II
Creator II

for table 

 

Max(Len(<Field>))

 

for title/text/variable :

 

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