topic Re: Color an individual cell in a table in QlikView

Color an individual cell in a table

Mon, 08 Dec 2014 14:15:32 GMT

Hello,

I recently exported a table from excel into qlikview and i am trying to color each invidiual cell depending on the value. If the value = 1, it should be green and if the value = 2 then it should be red. I tried doing this but it colors the entire table instead of the individual cell. How would i go about doing this where it only colors an individual cell.

Thanks,

Re: Color an individual cell in a table

morganaaron — Mon, 08 Dec 2014 14:19:19 GMT

Hi Brandon,

On the expression tab, on the expression you've created that shows 1 or 2, if you click the + sign on the left and click on the 'Background Color' option, it should allow you to type an expression into the definition box.

What you'll want is an expression along the lines of if([your expression]=1,Green(),if[your expression]=2, Red(),)) that will colour it depending on your results. You could use a Match statement or similar idea to get the same result!

Re: Color an individual cell in a table

rajeshvaswani77 — Mon, 08 Dec 2014 14:23:27 GMT

Hi Brandon,

You can go to User Preferences, Design tab and check Always show design menu items.

Next go to a table, right click the cell and say custom format cell. Here you can color the cell.

thanks,

Rajesh Vaswani

Re: Color an individual cell in a table

its_anandrjs — Mon, 08 Dec 2014 14:23:35 GMT

Hi,

If it is dimension the try with click on the plus sign and in Background write

BackGround

=if(FieldName = 1 ,Green(),Red() )

Text Color

White()

Regards

Anand