5 Replies Latest reply: Sep 16, 2014 4:23 PM by Kalpesh Jain RSS

    YTD

      Hi All

       

      The below note is taken from qlik developer ebook, As per the below instruction, how do i create Max (period) expression in qlikview

       

       

      A simple Max(Period) expression will help us get the base period in all scenarios,

      as the Period field contains both the Month and Year components. Therefore, the set

      modifiers that we would use to get the record set corresponding to the base period in

      each of the required comparisons are:

      • Current Year-To-Date indicators:

      <Period = {"<=$(=Max(Period))"}, Year = {"$(=Max(Year))"}, Quarter= , Month = >

      This set modifier will result in a record set containing all of the periods that

      are less than or equal to the current period, and belong to the current year,

      which would be all Year-To-Date records.