Line chart showing salary data over time

[astitzel]

Hi all - hopefully there is an easy solution to this fairly simple ask.

I am trying to show employee salary data overtime in a line chart. The line chart is included in a dashboard that shows end of year performance data for each employee. I have three salary values for each employee that represent individual salaries at 6 month intervals.

I have included a dummy data set that mimics my employee salary data set. Any guidance would be much appreciated. Thank you!

[dplr-rn · Accepted solution]

do a cross table load and convert the headers into column values
i.e. your dta is loaded into qlik like this
name Date Salary
https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

then its fairly striaght forward line chart

[Brett_Bleess]

Ann, did Dilip's post help you get things working as you wanted?  If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit and let others know that things did work for the use case.  If you are still working on things, leave an update.

Regards,
Brett