topic Green, Grey, White, . . yellow ? in QlikView

Green, Grey, White, . . yellow ?

Tue, 07 Jan 2014 13:15:55 GMT

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,

Re: Green, Grey, White, . . yellow ?

Anonymous — Tue, 07 Jan 2014 13:25:25 GMT

Hi,

Could you post the youtube link?

Re: Green, Grey, White, . . yellow ?

sandeepprasad_j — Tue, 07 Jan 2014 13:25:45 GMT

Hello Melanie,

Go through this link

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

Hope it helps

Thanks in advance

Sandeep

Re: Green, Grey, White, . . yellow ?

ngulliver — Tue, 07 Jan 2014 13:26:04 GMT

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

Re: Green, Grey, White, . . yellow ?

dmohanty — Tue, 07 Jan 2014 13:27:54 GMT

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!!

Re: Green, Grey, White, . . yellow ?

hic — Tue, 07 Jan 2014 13:33:04 GMT

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

Re: Green, Grey, White, . . yellow ?

Anonymous — Tue, 07 Jan 2014 13:33:36 GMT

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

Re: Green, Grey, White, . . yellow ?

john_duffy — Tue, 07 Jan 2014 13:34:51 GMT

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.

Re: Green, Grey, White, . . yellow ?

Tue, 07 Jan 2014 13:35:11 GMT

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

Re: Green, Grey, White, . . yellow ?

sebastiandperei — Tue, 07 Jan 2014 13:35:33 GMT

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.

Re: Green, Grey, White, . . yellow ?

john_novello — Tue, 07 Jan 2014 13:41:10 GMT

I've used yellow to highlight exceptions in the data for the end user.

Re: Green, Grey, White, . . yellow ?

Anonymous — Tue, 07 Jan 2014 13:45:28 GMT

Without having seen the actual video I think Henric has the correct answer. You could also encounter blue if your selections are locked. I seem to remember red as a colour as well but cannot remember in what context. I think it was in older versions.

Re: Green, Grey, White, . . yellow ?

Colin-Albert — Tue, 07 Jan 2014 13:52:34 GMT

Hi MW,

You will also see Blue highlighting in a listbox to show locked selections.

Re: Green, Grey, White, . . yellow ?

hic — Tue, 07 Jan 2014 13:54:08 GMT

You can get Red as state color if you use AND mode. A ctrl click will toggle between green white and red if you keep the mouse key pressed. This way you can ask "Which X does NOT have Y as attribute?"

HIC

Re: Green, Grey, White, . . yellow ?

Anonymous — Tue, 07 Jan 2014 14:13:47 GMT

Thanks!

I knew I had seen it before

Re: Green, Grey, White, . . yellow ?

Wed, 08 Jan 2014 16:52:27 GMT

Wow. This is fantastic information Henric. I had only seen green, grey and white before. Thanks.

Re: Green, Grey, White, . . yellow ?

Thu, 16 Jul 2015 13:15:56 GMT

Interesting but I can only toggle between green and white, should I enable any preferences to make this work?

Re: Green, Grey, White, . . yellow ?

Thu, 16 Jul 2015 13:17:06 GMT

Can there be a situation with both white and yellow?

Re: Green, Grey, White, . . yellow ?

hic — Thu, 16 Jul 2015 14:08:23 GMT

You need to choose a special color scheme: "Light". (Under Document properties - General). And then you need to enable "Show Alternatives" for the list box. (Under Properties - General). Then it should work.

HIC

Re: Green, Grey, White, . . yellow ?

Fri, 17 Jul 2015 08:06:51 GMT

hmm, I am using another Style and styling mode, but even after changing that, it does not work... Anything else I could do. QV 11.20 SR 12.