5 Replies Latest reply: Jul 23, 2010 4:35 AM by Bollietest RSS

    I need to change the background color for values of a particular column. The issue is that there's no consistent rule, which can be applied at the column level, in order to change the background color for all values of that column. The formula


      Please refer to the attached xls file. This would serve as a data source for my qlikview document. In the xls, there's one column known as RAG. This column values have different background colors. You will notice that the formula used for changing the background colors for different cells is different for most of the rows, and is not consistent for all the column values.

      In order to import this data into Qlikview, is there a way I can get the correct background colors for all the vaues of the RAG column?

      Pls. help.