Display a Value from an interval

crystles — Fri, 10 Mar 2017 18:04:29 GMT

I have an Interval for Part Codes. It works correctly and will show the correct code if a Date within that interval (Transaction/Count) is available

Here is an example of a part, that has three intervals.

I then have two "Transactions" or Counts of the part that I can show what the ChangeCode was for that specific Count date.

But NOW I need to show what that code was for each Quarter for the Current and Prior years, even if I don't have a Count in that Quarter.

I need two tables that will display the data as shown below, but I can't figure out how to get it to work correctly.

(NOTE: Our Fiscal Year starts in October)

topic Display a Value from an interval in QlikView