topic How to compare a daily base to a monthly base week by week? in QlikView https://community.qlik.com/t5/QlikView/How-to-compare-a-daily-base-to-a-monthly-base-week-by-week/m-p/474452#M555007 <HTML><HEAD></HEAD><BODY><P>Hi, everyone. I'm new to QlikView.</P><P></P><P>I'm having problems to develop a graphic. I want to compare my "actual" to my goal. I have this database from where I can count my actual amount day by day and another base where I have monthly goals. In my graphic, I compare actual and goal week by week. To sum the days to make the actual weeks is pretty ok to me, but I'm finding a hard time to <STRONG>divide the monthly goal into average days and the add them up to create the weekly goal</STRONG>. I need to do that because users can choose how many days each week will have, as long as they complete the number of days of that month. Eg. January -&nbsp; Week 1 = the first 10 days, Week 2 - 6 days, <SPAN style="font-size: 10pt;">Week 3 - 8 days, Week 4 - 7 days.</SPAN></P><P></P><P>I've tried to create a calculated expression to be my "daily goal", but I'm not even close. You can check the file Graphic 1 to understand it better.</P><P></P><P>[actual] is daily</P><P>[goal]&nbsp; is monthly</P><P></P><P>Thank you very much.</P></BODY></HTML> Wed, 07 Aug 2013 17:21:45 GMT 2013-08-07T17:21:45Z How to compare a daily base to a monthly base week by week? https://community.qlik.com/t5/QlikView/How-to-compare-a-daily-base-to-a-monthly-base-week-by-week/m-p/474452#M555007 <HTML><HEAD></HEAD><BODY><P>Hi, everyone. I'm new to QlikView.</P><P></P><P>I'm having problems to develop a graphic. I want to compare my "actual" to my goal. I have this database from where I can count my actual amount day by day and another base where I have monthly goals. In my graphic, I compare actual and goal week by week. To sum the days to make the actual weeks is pretty ok to me, but I'm finding a hard time to <STRONG>divide the monthly goal into average days and the add them up to create the weekly goal</STRONG>. I need to do that because users can choose how many days each week will have, as long as they complete the number of days of that month. Eg. January -&nbsp; Week 1 = the first 10 days, Week 2 - 6 days, <SPAN style="font-size: 10pt;">Week 3 - 8 days, Week 4 - 7 days.</SPAN></P><P></P><P>I've tried to create a calculated expression to be my "daily goal", but I'm not even close. You can check the file Graphic 1 to understand it better.</P><P></P><P>[actual] is daily</P><P>[goal]&nbsp; is monthly</P><P></P><P>Thank you very much.</P></BODY></HTML> Wed, 07 Aug 2013 17:21:45 GMT https://community.qlik.com/t5/QlikView/How-to-compare-a-daily-base-to-a-monthly-base-week-by-week/m-p/474452#M555007 2013-08-07T17:21:45Z