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

Announcements
Join us in Toronto Sept 9th 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