Deciphering an expression

[waynepcox]

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.

[rajeshqvd]

This ("{<FiscalYear={'$(=maxstring(FiscalYear))'}>}")  will show Maximum of FiscalYear .

[Anonymous]

Its a Set Analysis which is counting the number of unique ProposalID's in the most recent financial year. Here's a link to the set analysis help pages;

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-ana...