topic Merge Header column in pivot table qliksense in App Development

Merge Header column in pivot table qliksense

gayatri7 — Tue, 18 Jul 2023 08:13:39 GMT

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

Re: Merge Header column in pivot table qliksense

Or — Tue, 18 Jul 2023 09:44:05 GMT

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)

Re: Merge Header column in pivot table qliksense

gayatri7 — Tue, 18 Jul 2023 12:59:02 GMT

Thank you so much for your quick idea.

It worked perfectly.

Thanks and Have a nice day!😊