QlikView: Using Associative Search as List Box Search Mode

Qlik Technical Article

Article sections

    Summary: An article to advise users on setting up the associated search in QlikView
    Article Type: Information / Support
    Related Product(s): This article relates to the following products:

    • QlikView
    Related Articles:

    Qlik is the only vendor in the Business Intelligence arena with Associative Search.  This is displayed via the Green/White/Grey indicators and in the majority of scenarios, the associated fields can be made visible on a sheet to allow for a suitable range of selections.  However, the Associative Search capability can be utilised directly against a single list box.  This can make for a wider range of selection options, quicker selections and better use of the space on the sheet.

    Below an example requirement is set out followed by the default search mode and then the Associative Search mode solution.  After which instructions on setting up the associative search mode is outlined.

    Scenario

    A user wants to know the sales details for all the sales reps that have made sales in Germany.

    Normal Search Mode
    The step to get the correct result in normal search mode would be:

    1. Select “Germany” in Region list box.
    2. Right click and Select Possible on Sales Rep list box.
    3. Either via Current Selections box or Region list box de-select “Germany”.

    Associative Search Mode
    The step to get the correct result in associative search mode would be:

    1. Click on the Search icon on Sales Rep list box.  Start typing “Germany”, select “Germany” under Region heading.

    Associative Search Mode

    Setting up Associative Search Mode on a list box

    To allow users to use the associative search on a list box right click on list box > PropertiesSetting Up Associative Search Mode

    Under the General tab, click on the down arrow against “Default Search Mode” and select “Use Associative Search”
    Then click on “More Search Settings” button

    More Search Settings Screen

    Select the related fields by which you wish to allow an associative search and use the “Add” button to move across to right-hand side and make available > OK > OK

    Related Information:
    in Qlikview
    Share This Post
    Share on facebook
    Share on linkedin
    Share on twitter
    Share on email
    More To Explore

    Ready to Talk about your Project?
    Book a free Discovery Call

    A no obligation call to discuss your business needs and project requirements. During the call, our consultant will explain how we can help you to achieve your goals and answer any questions you may have.