Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

niccolo24
New Contributor II

set analysis - expression in Identifier

Hi guys,

this expression isn't working, can you give me a hint on what is wrong? The problem is in the identifier where I need to extract the year of dimension ASS_DTA_MAKEDATE (format 'MM/YYYY')

sum({<year(ASS_DTA_MAKEDATE)= {'$(=Date(yearname(today()),'YYYY'))'}>}, ASS_DBL_RN)

Thanks,

n

3 Replies

Re: set analysis - expression in Identifier

You need to create below field in script itself.

year(ASS_DTA_MAKEDATE) as Year


now use as below


sum({<year= {'$(=Year(Today()))'}>}, ASS_DBL_RN)

simondachstr
Valued Contributor III

Re: set analysis - expression in Identifier

Your expression has a , before the field - remove that.

Try the below:

sum({<ASS_DTA_MAKEDATE={"=Year(ASS_DTA_MAKEDATE) = $(=Date(yearname(today()),'YYYY'))"}>} ASS_DBL_RN)

Not applicable

Re: set analysis - expression in Identifier

Hi Niccolo,

If you absolutely have to do this without creating any new fields, then the below should work for you. However I would recommend creating a new year field and using that as per Manish's suggestion

Sum({<ASS_DTA_MAKEDATE= {">=$(=YearStart(today())) <=$(=YearEnd(today()))"}>} ASS_DBL_RN)

Hope that helps

Joe

Community Browser