topic Re: Adding Colour Scale to Straight Table Data in QlikView

Adding Colour Scale to Straight Table Data

Thu, 15 Aug 2013 17:57:25 GMT

I have a straight table

Team Sales 2013 Sales 2015 Sales 2015

Team A

Team B data

Team C

Team D

I want to implement a colour scale to the background of the data. (Like in Excel)

Any ideas?

Thanks

Re: Adding Colour Scale to Straight Table Data

Gysbert_Wassenaar — Thu, 15 Aug 2013 18:07:13 GMT

See this discussion for one option, using the colormix wizard.

Re: Adding Colour Scale to Straight Table Data

Fri, 16 Aug 2013 11:35:40 GMT

This is great Gysbert!

This only only takes into account colours for Sales 2013 though. If I replicate the steps for Sales 2014 then it colours them based on only the values in Sales 2014.

I want the color mix to reference all expressions - i.e ( Sales 2013, Sales 2014 and Sales 2015) at the same time.

Any ideas?

Re: Adding Colour Scale to Straight Table Data

Gysbert_Wassenaar — Fri, 16 Aug 2013 15:17:35 GMT

Try creating an example document so we can have a look: Preparing examples for Upload - Reduction and Data Scrambling