Highlight a row with color

[#1]

Hi

In SAP we have a concept of exception where in we show a colored display of certain rows depending on few conditions. Like

when sales<100 show in red, Sales >100&< 500 show in orange and when sales>500 show in green.

I saw a similar functionality in Qlikview in the pivot table.

Is it possible to display a similar thing in a table box object.

Thanks

Merlin

[#2]

Hi Merlin,

No, you cannot do this in Table Box.

-Peterson

[#3]

Hi Peterson,

Is there any other method other than the pivot table where we can highlight the values in color based on conditions?

[#4]

Hi Merlin,

You can do it in straight table, bar, line chart. i believe u can do in all type of charts.

-Peterson

[lmonincx]

hi,

if you open the dimension or expression name with the + you can enter an expression to the background to get the colour you want like

if(sum(X)>50,lightgreen(),ligthred())

regards,

linda