topic Re: Visual Cue - Max & Min Value in QlikView

Visual Cue - Max & Min Value

Anonymous — Tue, 23 Dec 2014 07:39:53 GMT

Hello to all,

I have a straight table that has some number values with expressions. I want to use the visual cues feature to have the highest value green and the lowest in red. If someone could just help with an expression to do that would be great.

Re: Visual Cue - Max & Min Value

manojkulkarni — Tue, 23 Dec 2014 07:47:47 GMT

In the visual cues, select expression and define upper & lower limit to show in respective colors.

eg: if sales margin is less than 5% then indicate in red. Actual expression will be <0.5 in lower limit

Re: Visual Cue - Max & Min Value

ecolomer — Tue, 23 Dec 2014 07:49:51 GMT

See this example

Re: Visual Cue - Max & Min Value

Anonymous — Tue, 23 Dec 2014 07:52:30 GMT

The values aren't percentages they are just numbers. So if the dimension is sales, what would the actual expression be for Max or Min.

Re: Visual Cue - Max & Min Value

jagan — Tue, 23 Dec 2014 08:17:51 GMT

Hi,

Please find attached file for solution. Used variables and Background Color option of expression to achieve this.

Regards,

Jagan.

Re: Visual Cue - Max & Min Value

Anonymous — Tue, 23 Dec 2014 08:32:57 GMT

I don't see an attachment, can you send again please

Re: Visual Cue - Max & Min Value

jagan — Tue, 23 Dec 2014 08:35:14 GMT

Hi,

I am able to see the attachment anyway I am attaching it again.

Regards,

Jagan.