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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display background color in Pivot table on selecting a year

I am using pivot table to display the data.  There are three years 2016 (current year),2015(Year-1),2014,(year-2) in the application.

When i select 2016, I have to display 2016,2015,2014

                     2015 -  2015,2014

                     2014 - 2014

I use a condition in the background color in each expression and in the dimension - year field.  When i select 2016, the background color for columns corresponding to 2014 and 2015 disappears. When i select 2015, the background color in 2014 disappears.

I want to show the color always when i select the year. 2016  - max(year), 2015 - max(year)-1, 2014 - max(year)-2

Before selecting the year

before.png

After selecting the year 2016

after.png

20 Replies
Not applicable
Author

@anil :  Thanks for helping me to solve this problem.  I have many pivot table in the application.  Now background color is working.