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

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

cgaleaQlik — Sat, 16 Nov 2024 18:19:59 GMT

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

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

lironbaram — Wed, 22 Jul 2020 06:57:26 GMT

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