Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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