one solution could be:
tabTemp: LOAD * FROM [https://community.qlik.com/thread/238408] (html, codepage is 1252, embedded labels, table is @1); tabEmps: LOAD [Emp Name], If([Emp Name]=Previous([Emp Name]), Previous(Amount), Amount) as [Old Amount], If([Emp Name]=Previous([Emp Name]), Amount , 0) as [New Amount], [Start Date] as [Last Change], AutoNumber([Start Date],[Emp Name]) as ChangeNo Resident tabTemp Order By [Emp Name], [Start Date]; DROP Table tabTemp; Right Join (tabEmps) LOAD [Emp Name], ChangeNo Resident tabEmps Where [Emp Name]<>Previous([Emp Name]) or ChangeNo>1 Order By [Emp Name], ChangeNo desc; DROP Field ChangeNo;
hope this helps
Could also do this:
Dimension 1 = Emp Name
Expression 1 = above(Amount)
Dimension 2 = Amount
Expression 2 = if(above(Amount),only([Start Date]))
But I usually don't like relying on chart inter-record functions because I don't usually like how they behave when I start making selections. I usually prefer modifying the data structures if I find myself doing chart inter-record functions.
Also, it doesn't give you the Jon line, but the Jon line makes no sense to me - Jon's salary did not go from 1600 to 0 on 2016-09-01. It went from 0 to 1600. But no other employees are showing a transition from 0 to their initial salary. So it just doesn't seem like Jon belongs in the chart.
See attached. Borrowed Marco's example.