Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Visual Cue - Max & Min Value

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.

Tags (1)
6 Replies
Highlighted
Partner
Partner

Re: Visual Cue - Max & Min Value

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

Highlighted
Master II
Master II

Re: Visual Cue - Max & Min Value

See this example

Highlighted
Contributor III
Contributor III

Re: Visual Cue - Max & Min Value

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.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Visual Cue - Max & Min Value

Hi,

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

Regards,

Jagan.

Highlighted
Contributor III
Contributor III

Re: Visual Cue - Max & Min Value

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Visual Cue - Max & Min Value

Hi,

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

Regards,

Jagan.