

- Move Document
- Delete Document and Replies
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Really very nice one. I cleared this doubt. Thank you for sharing.


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Thank you for sharing.

- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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!


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.

.png)
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
... and we in fact had "show alternatives" from the very beginning:
See also A Historical Odyssey: QlikView 1
HIC


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
And a marble background.


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
@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.