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.