2 Replies Latest reply: Jul 5, 2018 11:06 AM by Josh Pinfold RSS

    Deciphering an expression

    Wayne Cox

      Hi there,

       

      I am new to Qlik.  We had a consultant build some dashboards for us and I am trying to decipher one of his expressions.  It's a measure he created and this is the expression:

       

      count({<FiscalYear={'$(=maxstring(FiscalYear))'}>}distinct ProposalD)

       

      ProposalD is a field in a table.

       

      FiscalYear is defined in Calendar section as:  YearName(TempDate, 0, $(vFiscalYearStartMonth)) AS FiscalYear

       

      TempDate is defined as:  Date($(vMinDate) + RowNo() - 1) AS TempDate

      and vFiscalYearStartMonth = 4

       

      I can't figure out what the set expression {<FiscalYear={'$(=maxstring(FiscalYear))'}>} is doing.

       

      Thanks,

       

      Wayne.