Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Color gradient on a QlikView straight table

Hello Community

I wanted to get your views and suggestions on how we can achieve the color gradient on a QlikView straight table. Below is the table where I want to color code (gradient) the column CY vs PY.

2019-01-22_15-07-37.jpg

Below is a sample of how I want this to appear. Please see the color gradient from Blue (positive) to Red (negative).

2019-01-22_15-07-01.jpg

Below is a snapshot from excel showing how it is done. Can you suggest how we can achieve same in QlikView?

2019-01-22_15-06-14.jpg

Attached is a sample qvw for testing.

11 Replies
Highlighted
Specialist
Specialist

Thanks much for sharing the insights on this. The link you provided gave me a new direction and I was able to figure it out.

For others who may have similar ask, I referred the link shared by @Vegar and also below additional links.

https://www.youtube.com/watch?v=bxFrlwB9FQc
https://qlikfreak.wordpress.com/2014/03/09/heat-map/

In case you are wondering, here is the snapshot of how my app is now looking. I am also attaching my original qww with the solution now.

2019-01-24_16-05-30.jpg

Highlighted
Partner
Partner

Great! Good work @montubhardwaj.

It's really nice of you to sum up your issue in a closing comment where you also include a picture and a qvw file. 

Kudos!

Plees ekskuse my Swenglish and or Norweglish spelling misstakes