Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
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.