Using FirstSortedValue in the Script

    Hi,

     

    I have been looking into FirstSortedValue funtion within a script. Here is an example which uses the function within a loop transforming the original data to either one with flags or a new dimension feild.

     

    Original Data

    Picture1.jpg


    Added Flags

    Picture2.jpg


    New Dimension

    Picture3.jpg

     

    I will upload a more detailed walkthough on my blog soon (www.qlikCentral.com).

     

    For a good examlpe of using the funcion within the user interface please see this blog "Straight (and Pivot) Tables - more food for thought" (http://community.qlik.com/docs/DOC-6046) by Jason Michaelides

     

    Richard