Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This ("{<FiscalYear={'$(=maxstring(FiscalYear))'}>}") will show Maximum of FiscalYear .
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;