This can't be achieved using Set Analysis i believe. Because, set analysis works once for an object, i.e, it would not produce different results based on your dimension values. You have to work in the script; use some sort of As-of-Date concept or a linkage table. PFA, it might give you an idea.
Update: This link would be helpful. Look at the attachment by milda113.
base on my experience you can develop a simple to a little advance qvw apps.. but there are so man details to take in consideration when you are working alone.
im using qv in 2 years now and what im lacking for is the GUI deign aspect and some few data model expertise. but if your apps is more on aggregation and as reporting tool, QV is the most effective reporting tool for me..