Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
MK_QSL
MVP
MVP

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
Luminary Alumni
Luminary Alumni

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
Author

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