topic Re: How to display multiple field names as one column name ? in QlikView

How to display multiple field names as one column name ?

claudialet — Tue, 29 Jan 2019 16:27:20 GMT

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

Re: How to display multiple field names as one column name ?

sunny_talwar — Tue, 29 Jan 2019 16:37:44 GMT

How about this

Company_Number & Chr(10) & Company_Name & Chr(10) & Company_Code

Re: How to display multiple field names as one column name ?

claudialet — Tue, 29 Jan 2019 16:51:25 GMT

No I only got 2 rows

It is showing as 123Company

001

Re: How to display multiple field names as one column name ?

sunny_talwar — Tue, 29 Jan 2019 17:01:36 GMT

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

Re: How to display multiple field names as one column name ?

claudialet — Tue, 29 Jan 2019 17:04:51 GMT

Yes

Re: How to display multiple field names as one column name ?

sunny_talwar — Tue, 29 Jan 2019 17:14:28 GMT

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

Re: How to display multiple field names as one column name ?

claudialet — Tue, 29 Jan 2019 17:20:17 GMT

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) & )))

Re: How to display multiple field names as one column name ?

sunny_talwar — Tue, 29 Jan 2019 17:23:26 GMT

Looks okay, may be someone else have ideas here.

Re: How to display multiple field names as one column name ?

claudialet — Tue, 29 Jan 2019 17:38:51 GMT

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 ?

Re: How to display multiple field names as one column name ?

sunny_talwar — Tue, 29 Jan 2019 17:54:43 GMT

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. 🙂

Re: How to display multiple field names as one column name ?

claudialet — Tue, 29 Jan 2019 17:56:50 GMT

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

Re: How to display multiple field names as one column name ?

dplr-rn — Tue, 29 Jan 2019 18:00:23 GMT

Did you try increasing header height to 3 lines in Presentation tab

Re: How to display multiple field names as one column name ?

claudialet — Tue, 29 Jan 2019 18:08:42 GMT

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

Re: How to display multiple field names as one column name ?

dplr-rn — Tue, 29 Jan 2019 18:20:54 GMT

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

Re: How to display multiple field names as one column name ?

rwunderlich — Tue, 29 Jan 2019 19:44:44 GMT

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

Anyone else have a different experience?

-Rob