Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
I am working with QlikSense. So I do not have this fancy looking menu. Can you provide the script code it generates? Thanks.
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.