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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
claudialet
Contributor III
Contributor III

How to display multiple field names as one column name ?

 Hello  I  have 3 fields:   Company_Number ,  Company_Name and Company_Code 

 

Using this expression for field name : 

Company_Number  & '' &  Company_Name & '' &  Company_Code& ''

I get :   123Company001 

 

The result I  want  for a column header is 3 separate rows  :      123 

                                                                          Company 

                                                                              001 

14 Replies
claudialet
Contributor III
Contributor III
Author

  Does the Chr() apply to field names with numbers in them ?

 

dplr-rn
Partner - Master III
Partner - Master III

Did you try increasing header height to 3 lines in Presentation tab
claudialet
Contributor III
Contributor III
Author

 It's Qliksense Pivot I can only Indent or Fully expand 

 

 Does the Chr () work for mixed string/number fields ?

 If I have a Company Name like  Nike666     , CompanyNumber is  001 and Company Code  is  ABC 

   Noticed strings with numbers are still stuck together like :  001Nike666

                                                                                                                              ABC

 

dplr-rn
Partner - Master III
Partner - Master III

Its qlik sense? You posted on qlikview community hence the confusion.
On Sense i am not sure if its possible. good luck
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I don't think you can force a line break in Qlik Sense.  QlikView yes, Sense, no. 

Anyone else have a different experience?

-Rob