Set Analysis question

[Oleg_Troyansky]

Folks,

I'm having a brain freeze, please help!

I have daily Sales numbers and monthly Plan numbers. The monthly Plan is recorded with the date of the MonthStart() - e.g. 1/1/2009, etc...

I want to show a line chart with daily sales and average daily Plan (e.g. the Plan for the same Month divided by 20). Can I do it with the set analysis? No matter what I do, I'm getting some numbers only on the 1st of each month, but not on other dates...

thanks in advance!

Oleg

[#2]

Don't know your data model but you could put the Plan number in a separate table, linked by Month (or MonthYear), then it would be associated with all daily values.

Tom

[danielrozental]

Oleg, can you post a sample app for us to take a look at?

[Oleg_Troyansky]

Folks,

here is a sample that I generated to demonstrate the problem. The sales have daily numbers and the budget - only monthly (recorded on the 1st of each month). Because Sales and Budget have more than one key in common, I chose to concatenate the tables (in the real application, there are more tables that are concatenated together), and it's not too easy to use Link Tables instead...

appreciate any ideas,

Oleg

[danielrozental · Accepted solution]

Oleg,

Took a few try at your sample app, can't really see a way to use set analysis for this. If it's just a graph you need you may want to consider changing the line style to "plateau" else you would need to add Year/Month dimensions to make it work.

You might also want to consider loading the budget already distributed per date.

Here's what I got so far...

http://community.qlik.com/members/danielrozental/files/sample-budget-app-v1.qvw.aspx

[Oleg_Troyansky]

Thanks Daniel!

Plateau is a brilliant work around! Haven't thought of it.

thanks!

Oleg