Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Green, Grey, White, . . yellow ?

Hi,

I have just seen a demo on Youtube where the QlikView developer is using yellow as well as green and white.

What does yellow mean, and how do you get to use it ?

Thanks,

MW

1 Solution

Accepted Solutions
ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, MW.

Yellow is a 'Show alternatives' function for List boxes

List Box Properties - General - Show alternatives

The definition in Help is:

'Toggles whether a selection directly in the active field list box is to exclude the other values of the field or not. If Show Alternatives is checked, all values except the selected value will be displayed as Optional but may become excluded by association with selections in other fields. Otherwise, all other values are shown as excluded by default. This option is not available for calculated fields.'

There is a blog that explains this in more detail:

http://www.quickintelligence.co.uk/the-power-of-yellow/

Regards,

Neil

View solution in original post

22 Replies
Anonymous
Not applicable
Author

Hi,

Could you post the youtube link?

sandeepprasad_j
Creator
Creator

Hello Melanie,

Go through this link

Using QV Extensions: Change the green selection color ← Matt Floyd

Hope it helps

Thanks in advance

Sandeep

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, MW.

Yellow is a 'Show alternatives' function for List boxes

List Box Properties - General - Show alternatives

The definition in Help is:

'Toggles whether a selection directly in the active field list box is to exclude the other values of the field or not. If Show Alternatives is checked, all values except the selected value will be displayed as Optional but may become excluded by association with selections in other fields. Otherwise, all other values are shown as excluded by default. This option is not available for calculated fields.'

There is a blog that explains this in more detail:

http://www.quickintelligence.co.uk/the-power-of-yellow/

Regards,

Neil

dmohanty
Partner - Specialist
Partner - Specialist

Yellow is a Color Function in QlikView with RGB representation of RGB (255,255,0)

Please check 'Color Functions' in Help for other various color functions.

Regards!!

hic
Former Employee
Former Employee

Yellow is sometimes used to show "Alternative values", i.e. values that are excluded by a selection of another value in the same field, but not excluded by any selections in other fields.

List box properties -> General -> Show Alternatives

HIC

Alteratives.png

Anonymous
Not applicable
Author

I was assuming that that yellow was used in some other context than just as a colour function.

john_duffy
Partner - Creator III
Partner - Creator III

Hi Melanie.

The yellow background can be obtained by activating the Show Alternatives option on the List Box General properties tab.

Here is a link to an article explaining this functionality: http://www.quickintelligence.co.uk/the-power-of-yellow/

John.

Not applicable
Author

You can use the function "yellow()" as well if you don't know the RGB values.

sebastiandperei
Specialist
Specialist

Color functions are Yellow(), Green().... or RGB(red,green,blue)

These functions could be placed in [+] symbol, at the left of expressions or dimmentions, in Font Color, or Backgr. Color.

There, you can put an expression like:

If (expression_name > 1000, Yellow(150), RGB(100,100,100))

It should paint (font or back, depends on when you have putted it) the value in yellow if >1000, or gray if not.