In the Qlikview file attached here, I display a line chart with dimension "Year" limited to first 5 values. I want a variable "tempYear" to be updated with the rightmost (highest) value of the year displayed in the line chart. Currently I've hard coded the value of variable "tempYear" to 2005. But I want it to get updated if dimension limit is changed. For example, if dimension limit is changed to 6, the variable "tempYear" should be udated to 2006 (rightmost value of line chart in this case).
Please help me in achieving this.
