Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
waynepcox
New Contributor

Deciphering an expression

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.

2 Replies
rajeshqvd
Contributor

Re: Deciphering an expression

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

joshpinfoldold
New Contributor III

Re: Deciphering an expression

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...

Community Browser