Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cgaleaQlik
Contributor II
Contributor II

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

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. 😊

QlikView_Value_For_Last_Data_Pt.PNG

 Thank you,

Charles

 

Labels (3)
1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hi 

you can achieve this using those expressions 

image.png

 

 

 

 

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 

image.png

View solution in original post

1 Reply
lironbaram
Partner
Partner

hi 

you can achieve this using those expressions 

image.png

 

 

 

 

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 

image.png