Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

QlikView App: The Power Of Yellow (Show Alternatives)

cancel
Showing results for 
Search instead for 
Did you mean: 
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

QlikView App: The Power Of Yellow (Show Alternatives)

Last Update:

May 29, 2013 3:39:56 PM

Updated By:

stevedark

Created date:

May 29, 2013 3:39:56 PM

Attachments

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

http://www.quickintelligence.co.uk/

Comments
Anonymous
Not applicable

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

ysj
Creator
Creator

Thank you for sharing.

evan_kurowski
Specialist
Specialist

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!

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

hic
Former Employee
Former Employee

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

QV 1.png

See also A Historical Odyssey: QlikView 1

HIC

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

And a marble background. 

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

@hic I notice now Sense has the ability to natively style objects to have a background image - so I can now add a marble background to all my tables in Sense.

Version history
Last update:
‎2013-05-29 06:39 PM
Updated by: