topic Re: Custom Headers for Pivot Table in App Development

Custom Headers for Pivot Table

vikasmahajan — Wed, 24 Aug 2022 09:17:56 GMT

Hi Team,

I have heading like this

Sales$ YTD	Sales$ YTD	Sales$ YTD		Sales $ MAT	Sales $ MAT	Sales $ MAT
2020	2021	2022		2020	2021	2022

I wanted heading like this :

Sales$YTD -2020

Sales$YTD -2021

Sales$YTD -2022

Sales $ MAT-2020

Sales $ MAT-2021

Sales $ MAT-2022

I try with Time_Period &'-'& Year in heading but it is doubling the total is there any way to show heading in single line in Pivot table Qlik Sense.

Thanks in Adv

Vikas

Re: Custom Headers for Pivot Table

Mark_Little — Tue, 02 Aug 2022 11:59:57 GMT

You would have to create multiple measures, One for Each the YTD headers.

Re: Custom Headers for Pivot Table

vikasmahajan — Tue, 02 Aug 2022 12:05:56 GMT

Thanks for reply unfortunately I have 14 measures and 72 dimensions with 7 years of data in this pivot is there any dynamic way to show in single line instead of 2 lines ?

Period Type	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT
Year	2017	2018	2019	2020	2021	2022	Total	2017	2018	2019	2020	2021	2022

Thanks

Vikas