QlikView App: The Power Of Yellow (Show Alternatives)

[stevedark]

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/

[Anonymous]

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

[ysj]

Thank you for sharing.

[evan_kurowski]

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]

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]

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

See also A Historical Odyssey: QlikView 1

HIC

[stevedark]

And a marble background. 

[stevedark]

@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.