Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I want to create a table like below which is having some dimension and some measure but that measure are having two different headers, I am not getting how can i achieve this, can someone please guide me here.
I tried something like below, created one inline table and added the two columns in pivot table column
Header:
Load * Inline
[
Header 1 , Header 2
Header 1 , Sub Header 1
Header 1 , Sub Header 2
Header 1 , Sub Header 3
Header 12, Sub Header 1
.
.
Header 2 , Sub Header 5
];
But this is not working as shown in the image above, please help me to resolve this issue.
Thanks and Regards
Aslam Shaikh
Hey!
Take a look at this part of the Help site:
https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Pivot...
If you scroll down to "Pivoting your data in the table", the second image shows what you're trying to accomplish.
Thanks!
I've created a second inline with sub-header title and presented it in the pivot
Load * Inline [
dim1, dim2,header,subheader, value
A,AB,header1,header1,1
A,AC,header2,header2,2
A,AD,header1,header3,4
B,BB,header1,header1,1
B,BC,header2,header2,2
B,BD,header1,header3,4
];
Load * Inline [
header,subheader,title
header1,header1,t1-1
header1,header3,t1-3
header2,header2,t2-2
];
exit Script;