Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jsingh71
Partner - Specialist
Partner - Specialist

Super header in Pivot table

Hi All,

I need to create a pivot table in sense with super header, please see attached image.

 

 

Product is my dimension whereas 2015, 2016,,2017,2018 and 2019 are my EXPRESSIONS.

Thanks in advance. 

1 Reply
Wlad_Masi
Employee
Employee

Hello @jsingh71 ,

 

I attached an app that looks to be working as you expects.

Pivot.png

 

 

 


Basically I used Product as dimension, sum os Values as expression and the following two columns:

  • =if(Year >= (year(Today())-3), 'Last 3 Years', '> 3 Years')
  • Year

I hope it helps you.
Please mark the thread as solved if this is what you were looking for.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.