Missing Manual - GetFieldSelections() + Bonus Example

    Have you ever wondered how the examples from the Qlikview help may look like?

    Please see below and enjoy responsibly...

     

    GetFieldSelections()

     

    Definition:

     

    Returns a string with the current selections in a field.

    valueSep - is the separator to be put between field values. The default is ', '.

    max_values  - is the maximum number of field values to be individually listed.

                          When a larger number of values is selected the format 'x of y values' will be used instead.

                          The default is 6.

     

    Preparation:


    Script to play with:

     

    Load * Inline

    [

    Year

    2007

    2008

    2009

    2010

    2011

    2012

    2012

    2013

    2014

    2015

    2016

    ]

     

     

    Example 1:

     

    GetFieldSelections(Year )


    Our field Year has 10 values (Years from 2007 to 2016)

    The default separator is ',' (coma)

    The maximum default numbers of values is 6

     

    We used the same expression for all 3 sets of data

     

    Left: Selection of 6 values

    Middle: When more that 6 values the result will change to show the values which are not selected.

    Right: Selecting whole sets of values will return 'ALL' as result

     

    DataExpression and Results

     

     

     

    Example 2: valueSep


    We can assign here any character (or string).



    Examples 3: max_values

     

    The default values of 6 is overwritten by the value we have specified(10)

     

     

    Interesting:

    When playing with this function somehow I managed to get result like below

    If you can replicate it please post it.

     

    Bonus:

     

    Practical use:

     

    PROBLEM OF DIFFERENCE OF SUM

     

    Still feeling hungry?

    How to use - Only()

    Do you Qualify?- How to use QUALIFY statement

    How to use - Dimensionality()

    Missing Manual - GetFieldSelections() + Bonus Example

    MaxString & MinString - How to + examples

    The second dimension... or how to use secondarydimensionality()

    How to use - MissingCount()

    How to use- Dual()

    Expression Scene Investigation, E1: Moving Average