Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
astep1990
Contributor
Contributor

Splitting the Filed Name (Table's Header) into Two Separate Lines

I have a dataset of the following structure:

Company.ID  DDR (25632) PTL (89567)
2512             89         74
9875             78         96
7892             14         73

I would like to split the header into two different lines (Transformation must be done in Script). With other words the second part of the header should or could be the first variable. How is possible to transform the dataset into the desired form (see below):

Company.ID          DDR         PTL 
     -            (25632)     (89567)
    2512             89         74
    9875             78         96
    7892             14         73

To replicate the above example in Qlik, run the code below:

LOAD * Inline [
        [Company.ID], [DDR (25632)], [PTL (89567)]
        2512,89,74
        9875,78,96
        7892,14,73
    ];

Any help or tipp would be highly appreciated!

Labels (1)
3 Replies
Shubham_Deshmukh
Specialist
Specialist

Hi @astep1990 ,

Give the same name in Label and give some more spaces between DDR & (25632) and then enable Wrap Header Text option.
You can split them like this.w.png

 

astep1990
Contributor
Contributor
Author

I am working with QlikSense. So I do not have this fancy looking menu. Can you provide the script code it generates? Thanks.

Shubham_Deshmukh
Specialist
Specialist

Hi,

You should always mention which tool you are using.

In Qliksense also you can do this, in label give some more spaces between DDR & (25632) and adjust width of column manually.