Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
Former Employee
Former 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.