Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
montubhardwaj
Valued Contributor

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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Color gradient on a QlikView straight table

You will ned to stretch your expression in such a way that your minimum value is presented with -1 and your maximum +1.

You could take inspiration from this blog using colormix1 . https://qlikfreak.wordpress.com/2014/03/09/heat-map/
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

11 Replies
Partner
Partner

Re: Color gradient on a QlikView straight table

Take a look at the Qlikview colour function Colormix2()
It can be a bit tricky to get the colour span correct, but it should do the trick for you .
Cheers
Vegar
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
montubhardwaj
Valued Contributor

Re: Color gradient on a QlikView straight table

Thanks for the response. I looked at the Colormix function earlier but that did not work. I am not sure how to replicate the functionality in xls shown above in my example.
montubhardwaj
Valued Contributor

Re: Color gradient on a QlikView straight table

Somehow color gradient is not working with Set Analysis... not sure if I am missing something but...

Partner
Partner

Re: Color gradient on a QlikView straight table

Try to put your color expressions without the colormix2 wrapped around it as any expression in your object to check if your expressions are set up correctly.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
montubhardwaj
Valued Contributor

Re: Color gradient on a QlikView straight table

Yes, the expressions are fine... no error there. Its just that I am able to achieve the same or similar gradient as shown in xls.

Partner
Partner

Re: Color gradient on a QlikView straight table

Please take a look at the attached picture. The expression used is =colormix2((Column(5)-Column(4))/Column(4), blue(170),lightred(), white()).

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
montubhardwaj
Valued Contributor

Re: Color gradient on a QlikView straight table

Thanks for taking a shot at this. I don't think it is working as per how it defined in the xls sheet? Did you look at the attached xls snapshot and how the gradient is defined there?  I guess I am not seeing a condition which color the cells as in the xls. Am I missing something ?

Partner
Partner

Re: Color gradient on a QlikView straight table

You will ned to stretch your expression in such a way that your minimum value is presented with -1 and your maximum +1.

You could take inspiration from this blog using colormix1 . https://qlikfreak.wordpress.com/2014/03/09/heat-map/
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

montubhardwaj
Valued Contributor

Re: Color gradient on a QlikView straight table

interesting post. I will take a look at this. Thanks again for your suggestion.