Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

View solution in original post