Merge Header column in pivot table qliksense

[gayatri7]

Hello All,

I need to merge the header column in the pivot table as shown below.

I tried with the text box but the table is getting out of the screen (scroll bar) and could not fit the 7 textbox.

the expression MTD and % vs PY are grouped based on different IDs with descriptions as mentioned above. 

I tried with an inline table as well with ID and desc. but the description is repeating for all 7 columns.

Could anyone have any ideas to share? It will be a great help.

Thanks

Gayatri

[Or · Accepted solution]

There is no option to merge headers for measures in pivot tables. Only dimensions are merged. You would need to create this field as a dimension (using ValueList() or an inline load) and then write out your measures using e.g.

Pick(Match(InlineDimensionName,'Sales Volumes','ASP Product'),SomeFormula1,SomeFormula2)

[gayatri7]

Thank you so much for your quick idea. 

It worked perfectly.

Thanks and Have a nice day!😊