topic Year to Date Expression in QlikView

Year to Date Expression

Dmichel0729 — Thu, 04 Mar 2021 14:40:01 GMT

Hello All,

I am trying to create an expression that only shows the current year to date data in a Pie Chart for an element that has a status of 'On-Time'. Below is the used expression which presents me with a 'No data to display' error.

=Count({1<[Actual Revision Completion Status]={'On-Time'}, [Next Scheduled Effective Date] = {'$(=Year(Today()))'}>}[Actual Revision Completion Status])

I do have a Year field in my script and the Next Scheduled Effective date is in a date format.

Any help would be appreciated!

Thank you,

Dylan

Re: Year to Date Expression

rubenmarin — Thu, 04 Mar 2021 20:01:45 GMT

Hi, I think the best option here is to create a [Next Scheduled Effective Year] in script using Year([Next Scheduled Effective Date]), so you can use this field in set analysis.

Another option may be using something like: [Next Scheduled Effective Date] = {"*/$(=Year(Today()))"}, it assumes than date is in DD/MM/YYYY or MM/DD/YYYY format.

Re: Year to Date Expression

datagrrl — Thu, 04 Mar 2021 20:21:46 GMT

Have you tried doing the Year of the date equal to this year

Do you have a master calendar? I would just use the year from that because right now you are comparing a date to a year.

Let me know if I am reading your question wrong.