topic Re: set analysis - expression in Identifier in QlikView

set analysis - expression in Identifier

Anonymous — Fri, 05 Sep 2014 11:07:53 GMT

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,

Re: set analysis - expression in Identifier

MK_QSL — Fri, 05 Sep 2014 11:09:46 GMT

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)

Re: set analysis - expression in Identifier

simondachstr — Fri, 05 Sep 2014 11:19:08 GMT

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)

Re: set analysis - expression in Identifier

Fri, 05 Sep 2014 12:00:57 GMT

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