topic Re: Color gradient on a QlikView straight table in QlikView

Color gradient on a QlikView straight table

montubhardwaj — Tue, 22 Jan 2019 21:22:43 GMT

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.

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

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

Attached is a sample qvw for testing.

Re: Color gradient on a QlikView straight table

Vegar — Tue, 22 Jan 2019 23:33:42 GMT

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

Re: Color gradient on a QlikView straight table

montubhardwaj — Tue, 22 Jan 2019 23:48:56 GMT

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.

Re: Color gradient on a QlikView straight table

montubhardwaj — Wed, 23 Jan 2019 15:44:54 GMT

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

Re: Color gradient on a QlikView straight table

Vegar — Wed, 23 Jan 2019 17:19:38 GMT

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.

Re: Color gradient on a QlikView straight table

montubhardwaj — Wed, 23 Jan 2019 20:00:52 GMT

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.

Re: Color gradient on a QlikView straight table

Vegar — Wed, 23 Jan 2019 21:23:14 GMT

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

Re: Color gradient on a QlikView straight table

montubhardwaj — Wed, 23 Jan 2019 21:30:12 GMT

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 ?

Re: Color gradient on a QlikView straight table

Vegar — Thu, 24 Jan 2019 07:40:30 GMT

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/

Re: Color gradient on a QlikView straight table

montubhardwaj — Thu, 24 Jan 2019 20:23:07 GMT

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

Re: Color gradient on a QlikView straight table

montubhardwaj — Thu, 24 Jan 2019 22:07:25 GMT

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.

Re: Color gradient on a QlikView straight table

Vegar — Thu, 24 Jan 2019 22:19:20 GMT

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!