Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.

QlikView App: The Power Of Yellow (Show Alternatives)

MVP & Luminary
MVP & Luminary

QlikView App: The Power Of Yellow (Show Alternatives)

The blog posting 'The Power Of Yellow' describes how Show Alternatives can be used to highlight data excluded by a selection on a field that would otherwise be included.  This QlikView application illustrates this functionality.

This tequnique can be useful in making immediately apparent something that would otherwise be hard to spot, or require extra clicks to remove selections.

For a full description of how and why the feature can be used please see the original blog post at: http://www.quickintelligence.co.uk/the-power-of-yellow/

Steve Dark



Really very nice one. I cleared this doubt. Thank you for sharing.


Thank you for sharing.

Valued Contributor

I love the 'Show Alternatives' feature..  My only request is I wish the 'advanced' listbox features would be functional when we code the list box with an expression. 

for example, if there were a large field of values, but in the UI in one section you know you only want to deal with a subset, and you sculpt away the extras with a set-expression, but still be able to use the Show Alternatives, etc.. 

But List Boxes may be my favorite control of all time.  For a while it was Text Boxes, but now it's all about the List Boxes!

MVP & Luminary
MVP & Luminary

It's an interesting historical fact, that the first releases on QwikView only had list boxes and nothing else, and it was still a viable product (thanks to hic‌ for demonstrating this at various events).

Personally I would always try and avoid having expressions in list boxes, but agree that there are times that you want to exclude some values.  If it's possible to do it at load time (so have two fields, one with all values and another with some values replaced with nulls) then I would do that.

Thanks for your comment.


... and we in fact had "show alternatives" from the very beginning:

QV 1.png

See also A Historical Odyssey: QlikView 1


MVP & Luminary
MVP & Luminary

And a marble background. 

Version history
Revision #:
1 of 1
Last update:
‎2013-05-29 06:39 PM
Updated by: