4 Replies Latest reply: Nov 24, 2011 6:28 AM by Dave Wright RSS

    FirstSortedValue

      Hi All,

       

      Please see attached table.

       

      I have a table with the data in Columns A - D, and I want to return the values in Columns E and F.

       

      I have tried using FirstSortedValue, which seems logically to be the function I should use, but I am not getting any returns.

       

      Column E shows the minimum YearPeriod value in Column A for the Group in Column C.

       

      In fact, all returns are "201001" because that is the minimum YearPeriod value for each Group.

       

      Likewise, Column F shows the minimum YearPeriod value in Column A for the Type in Column D.

       

      This time, there are some returns that are not "201001" (coloured) because there is no such YearPeriod value for these types.

       

      In QlikView-speak, I have unsuccessfully used the following:

       

      FirstSortedValue(TOTAL YearPeriod, Group)

       

      ...and, of course Type in place of Group for the second case.

       

      Yet again I am doing something wrong... yet again I throw myself at the feet of the all powerful community.

       

      Help Please!

       

      8-)

       

      Dave

       

       

      QlikView for Windows Version 9.00.7646.9 SR6

       

      Message was edited by: davewright - typo