topic Help creating a weekly variable from a monthly dimension. in QlikView https://community.qlik.com/t5/QlikView/Help-creating-a-weekly-variable-from-a-monthly-dimension/m-p/243255#M92906 <HTML><HEAD></HEAD><BODY><P>I have a straight table with Forecast by Country by Month (2011).&nbsp; I need to create a table that gives Forecast by Country by Week.&nbsp;&nbsp; For purposes of this request, I can assume that the numbers of weeks in each month equals the number of Saturdays in each month.&nbsp; Then I can take the Forecast for each month and divide by the number of Saturdays in each month to get a "rough" Foreacst by Week. </P><P></P><P>I can’t quite come up with the best approach/formula/expression/etc.&nbsp; Does anyone have any suggestions?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 02 Aug 2011 17:29:57 GMT 2011-08-02T17:29:57Z Help creating a weekly variable from a monthly dimension. https://community.qlik.com/t5/QlikView/Help-creating-a-weekly-variable-from-a-monthly-dimension/m-p/243255#M92906 <HTML><HEAD></HEAD><BODY><P>I have a straight table with Forecast by Country by Month (2011).&nbsp; I need to create a table that gives Forecast by Country by Week.&nbsp;&nbsp; For purposes of this request, I can assume that the numbers of weeks in each month equals the number of Saturdays in each month.&nbsp; Then I can take the Forecast for each month and divide by the number of Saturdays in each month to get a "rough" Foreacst by Week. </P><P></P><P>I can’t quite come up with the best approach/formula/expression/etc.&nbsp; Does anyone have any suggestions?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 02 Aug 2011 17:29:57 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-weekly-variable-from-a-monthly-dimension/m-p/243255#M92906 2011-08-02T17:29:57Z