Visual Cue settings - omit total

[anthony_kinsell]

Is there a way to omit the total from the settings entered for visual clues on a graph?

I have a word screen shot of my graph to show what I mean.

[Greg_Williams]

On Expressions tab > remove Total (lower right of window); otherwise - consider coloring fields using background color with a conditional coloring scheme.

[anthony_kinsell]

Thanks Greg - I want the total to show - I just don't want the visual cue settings to apply to it so removing the total isn't an option.

[IAMDV]

Anthony - Use Expression > Background Colour instead of Visual Cues.

[anthony_kinsell]

Not quite familiar with that Deepak - could you give an example of the definition you would use to say make the cell background green for values above 5?

[IAMDV]

I have made a video tutorial sometime back. Please see the below tutorial:

http://qlikshare.com/328/

Thanks,

DV

[maxgro · Accepted solution]

instead of visual cues use text color and background color of the expression in expression tab

dimensionality for get normal or total rows

example, for background color of VacantDays (label)

=if(Dimensionality()>0,

  if(VacantDays>=10,Green(),

  if(VacantDays>-0.01,Yellow(),

  yellow()

  ))

  ,

  black()

)