topic Set Analysis question in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141737#M505697 <HTML><HEAD></HEAD><BODY><P>Thanks Daniel!</P><P></P><P>Plateau is a brilliant work around! Haven't thought of it.</P><P>thanks!</P><P>Oleg</P></BODY></HTML> Tue, 21 Apr 2009 00:04:28 GMT Oleg_Troyansky 2009-04-21T00:04:28Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141732#M505691 <HTML><HEAD></HEAD><BODY><P>Folks,</P><P>I'm having a brain freeze, please help!</P><P>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...</P><P>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...</P><P>thanks in advance!</P><P>Oleg</P></BODY></HTML> Sat, 18 Apr 2009 00:47:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141732#M505691 Oleg_Troyansky 2009-04-18T00:47:51Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141733#M505692 <HTML><HEAD></HEAD><BODY><P>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.</P><P><BR />Tom</P></BODY></HTML> Sun, 19 Apr 2009 23:28:15 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141733#M505692 2009-04-19T23:28:15Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141734#M505694 <HTML><HEAD></HEAD><BODY><P>Oleg, can you post a sample app for us to take a look at?</P></BODY></HTML> Mon, 20 Apr 2009 20:14:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141734#M505694 danielrozental 2009-04-20T20:14:51Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141735#M505695 <HTML><HEAD></HEAD><BODY><P>Folks,</P><P>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...</P><P>appreciate any ideas,</P><P>Oleg</P></BODY></HTML> Mon, 20 Apr 2009 20:57:57 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141735#M505695 Oleg_Troyansky 2009-04-20T20:57:57Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141736#M505696 <HTML><HEAD></HEAD><BODY><P>Oleg,</P><P></P><P>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.</P><P></P><P>You might also want to consider loading the budget already distributed per date.</P><P></P><P>Here's what I got so far...</P><P>http://community.qlik.com/members/danielrozental/files/sample-budget-app-v1.qvw.aspx</P></BODY></HTML> Mon, 20 Apr 2009 21:38:53 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141736#M505696 danielrozental 2009-04-20T21:38:53Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141737#M505697 <HTML><HEAD></HEAD><BODY><P>Thanks Daniel!</P><P></P><P>Plateau is a brilliant work around! Haven't thought of it.</P><P>thanks!</P><P>Oleg</P></BODY></HTML> Tue, 21 Apr 2009 00:04:28 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/141737#M505697 Oleg_Troyansky 2009-04-21T00:04:28Z