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
sunny_talwar

How about this

Company_Number & Chr(10) & Company_Name & Chr(10) & Company_Code
claudialet
Contributor III
Contributor III
Author

  No I only got 2 rows 

It is showing as               123Company

                             001

sunny_talwar

Did you add Chr(10) between Company Number and Company Name?

claudialet
Contributor III
Contributor III
Author

 Yes 

 

 

sunny_talwar

That is strange that it worked one time and not worked another time. Can you share a sample to show the issue?

claudialet
Contributor III
Contributor III
Author

 I am unable to share data but here is the expression for a column in a  QS pivot table. 

=if($(vFilter)=1 and DomesticFlag=0 , Company_Number & Chr(10) &  Company_Name & Chr(10) & Company_Code ,

if($(vFilter)=4 and DomesticFlag=0 , Company_Name & Chr(10) & Company_Code & Chr(10) & )))

sunny_talwar

Looks okay, may be someone else have ideas here.

claudialet
Contributor III
Contributor III
Author

Is there any load function that should be used for the 3 fields : Company_Number, Company_Name and Company_Code to display it in 3 consecutive rows ?
sunny_talwar

If anything would work... it would be with Chr(10) or Chr(13)... you can try them... but not sure why Chr(10) will work once, but not twice. 🙂