Missing Manual - FieldValue

              1f4fe19.jpg       

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

    Please see below and enjoy responsibly...

     

    FieldValue()


    2015-04-21 04_31_52-field - Google Search.png


    This function belongs to Inter Record Functios and has few rules:


    • Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when Chart Inter Record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.
    • Suppression of zero values is automatically disabled when this functions is used


    Data Model


    (Copy and Pasted below code into Edit Script window and reload)


    LOAD * inline

    [

     

    HelpText,Name
    Block,Bob
    Color,John
    Topics,Jenny
    Font,Curt
    Data,Martin
    Group,Mirek
    Total,Stan


    ]


    Now create Straight table and  remember to sort dimension and expression by load order

     

    Returns values from position specified by second criteria (elem_no)


    • Works only with distinct value
    • field_name must be given as a string value (enclosed with single quotes ('))
    • If elem_no is larger than the number of field values, NULL is returned.


    Syntax:

    2015-04-21 04_50_44-New Text Object.png

     

    Field_name -  is a name of of your field(column)

    elem_no - position from the top

     

    Example



    fieldvalue( 'Helptext', 5 )

    2015-04-21 22_17_42-Microsoft Excel - Book1.png

     

    Bonus


    By using:

     

    =FieldValue('Name', RowNo()+1)

    =FieldValue('Name', RowNo()-1)

     

    you can shift values one row below/or above current one loosing the first or last value.

    2015-04-21 22_45_42-Microsoft Excel - Book1.png