topic Annualizing a yield - Bar Chart Expression in QlikView https://community.qlik.com/t5/QlikView/Annualizing-a-yield-Bar-Chart-Expression/m-p/821959#M1031499 <HTML><HEAD></HEAD><BODY><P>Folks</P><P></P><P>I am a newbie and sincerely appreciate your expert input.</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have a calculated expression that divides Sum of Income/Sum of Sales&nbsp;&nbsp; ... however What I need to do is have this yield calculation annualized by dividing it by the number of calendar days in the month x 365.</SPAN></P><P></P><P>Therefore, the January yield should be Sum of Sales/Sum of Balance/31*365</P><P></P><P>Similarly, each data point in the graph for the corresponding month should be annualized based on the number of days in the month.</P><P></P><P>How can I write this expression? I am creating a calendar as an object to specify the date range as well.</P><P></P><P>Thank you so much!</P></BODY></HTML> Tue, 17 Feb 2015 13:55:59 GMT 2015-02-17T13:55:59Z Annualizing a yield - Bar Chart Expression https://community.qlik.com/t5/QlikView/Annualizing-a-yield-Bar-Chart-Expression/m-p/821959#M1031499 <HTML><HEAD></HEAD><BODY><P>Folks</P><P></P><P>I am a newbie and sincerely appreciate your expert input.</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have a calculated expression that divides Sum of Income/Sum of Sales&nbsp;&nbsp; ... however What I need to do is have this yield calculation annualized by dividing it by the number of calendar days in the month x 365.</SPAN></P><P></P><P>Therefore, the January yield should be Sum of Sales/Sum of Balance/31*365</P><P></P><P>Similarly, each data point in the graph for the corresponding month should be annualized based on the number of days in the month.</P><P></P><P>How can I write this expression? I am creating a calendar as an object to specify the date range as well.</P><P></P><P>Thank you so much!</P></BODY></HTML> Tue, 17 Feb 2015 13:55:59 GMT https://community.qlik.com/t5/QlikView/Annualizing-a-yield-Bar-Chart-Expression/m-p/821959#M1031499 2015-02-17T13:55:59Z