topic Re: Visual Cue settings - omit total in QlikView

Visual Cue settings - omit total

anthony_kinsell — Thu, 01 May 2014 16:18:49 GMT

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.

Re: Visual Cue settings - omit total

Greg_Williams — Thu, 01 May 2014 16:22:49 GMT

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

Re: Visual Cue settings - omit total

anthony_kinsell — Thu, 01 May 2014 16:25:33 GMT

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.

Re: Visual Cue settings - omit total

IAMDV — Thu, 01 May 2014 16:28:55 GMT

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

Re: Visual Cue settings - omit total

anthony_kinsell — Thu, 01 May 2014 16:34:47 GMT

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?

Re: Visual Cue settings - omit total

IAMDV — Thu, 01 May 2014 16:41:16 GMT

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

http://qlikshare.com/328/

Thanks,

Re: Visual Cue settings - omit total

maxgro — Thu, 01 May 2014 16:43:29 GMT

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()

)