Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
cgaleaQlik
Contributor III
Contributor III

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 - Master III
Partner - Master III

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 - Master III
Partner - Master III

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