Show value for last data point in Line Chart with several lines of differing length

[cgaleaQlik]

Hello Everyone,

I have a line chart displaying 2 lines and would like to show the value for only the last data point for each line on the chart. The charts display data over time and the 2 lines cover different time periods. I have included a screenshot and example QlikView file. I'd appreciate any help you can provide. 😊

 Thank you,

Charles

[lironbaram · Accepted solution]

hi 

you can achieve this using those expressions 

and this for the second expression in the show value property 

=if(Date=max({<Date={"<$(=date('01/01/2018'))"}>}total Date),1,0)

 your chart will look like this