13 Replies Latest reply: Jun 28, 2016 12:49 PM by Tim Kendrick RSS

    How Do I set different background colors based on column label and value within that column?

    Shane Sapp

      Ok, so I'm new to Qlikview Sense so bear with me.

       

      Basically, I've got a pivot table that looks like this:

       

       

      Now, what I need to do is set conditional formatting on the column header.  For example, for "Basic DL" my "Green" condition might be values less than 950, but on "Basic Titles" my "green" condition might be values less than 900.  I've played around with the background color conditions and expressions (ColumnNo, Column, Lookup, etc), but I just cannot get the right combination of functions to get this right.  Any thoughts or help would be greatly appreciated.  Please note this is for Qlikview Sense Desktop.