Show values in text box with changing year information

[ZoeM]

Hi Qlik Community.

I have a text box overlaying a pivot chart, and in this text box I want to show the difference between the years selected of the stated expression.

My expression counts the number of late products year over year, when the user selects two subsequent years i want the text box to show the difference between those two years. My current expression is:

=count({$<[#of Days Post VPP]={">14"},CY=Max({<[CY]=>}[CY])>}CY)

I am sure there is a simple fix to this and I am just glossy eyed.

Thanks in advance.

[sunny_talwar]

CY is a year field, right? How do you create that in the script?

[ZoeM]

Yes CY is the year field.

The data is from a Power Query attached to a library data source and comes into QV that way. In the Script I renamed it so as to create a link to another table: