topic Re: Line chart showing salary data over time in QlikView

Line chart showing salary data over time

astitzel — Wed, 06 Nov 2019 16:12:45 GMT

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!

Re: Line chart showing salary data over time

dplr-rn — Wed, 06 Nov 2019 16:28:38 GMT

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

Re: Line chart showing salary data over time

Brett_Bleess — Tue, 12 Nov 2019 14:31:11 GMT

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