Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE

QlikView App: The Power Of Yellow (Show Alternatives)

stevedark
Luminary Alumni
Luminary Alumni

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

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

Attachments
Comments
niranjanqlik
Explorer
Explorer

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
Luminary Alumni
Luminary Alumni

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.

0 Likes
Henric_Cronström

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

QV 1.png

See also A Historical Odyssey: QlikView 1

HIC

stevedark
Luminary Alumni
Luminary Alumni

And a marble background. 

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