Most current salary

[#1]

I have a table with Salary history. I am trying to show a line chart with salary change over time. What should be the measure if my dimension is year>Month>?  If there is no salary entry for a particular month I would like to show the last applicable salary. For instance, for E2, the salary for 2015 should be zzz as it was in 2014.

Employee	Date	Salary
E1	June 2015	xxx
E1	Mar 2016	xxy
E2	Jan 2014	zzz
E2	Jan 2016	zcx

[swuehl]

I would fill in the missing records in the script:

Generating Missing Data In QlikView

[swuehl]

Or

Creating a Date Interval from a Single Date

Creating Reference Dates for Intervals

[#4]

Thank you Stefan, I did create a master calendar table and interval for date but I am having a hard time visualizing in graphically. How does one show interval data in a graph? If I use max(salary) as a measure with master calendar dimension (because there are other measures too) then it shows a straight line.

[swuehl]

Are your master calendar table and your fact table linked? If so, what are the key fields?

If you have created intervals, you need to create reference dates to link the intervals to your master calendar, either manually using the approach described in the referenced blog post or using INTERVALMATCH LOAD prefix.

If possible, upload a small sample QVW, this makes it easier to understand your issue and help you.

[#6]

Attaching the current data model. My final requirement is to show Salary, Bonus in the same line graph. Below are separate graphs one for Bonus and other for Salary over time. I wish to combine them. 

[swuehl]

Hard to say without knowing how for example the Datelink table was built and how the data sources look like.

It seems you already created a canonical date.

Canonical Date

Have you tried to use the common calendar as dimension and filter the facts like

=Sum({<Datetype = {Salary}>} Salary)

=Sum({<Datetype = {Bonus}>} Bonus)

Not sure if you want to sum the facts. Again, would be easier if we can look at the data.