topic Percent through the month/quarter in QlikView https://community.qlik.com/t5/QlikView/Percent-through-the-month-quarter/m-p/417102#M485048 <HTML><HEAD></HEAD><BODY><P>I need help with calculating the percent through the month and quarter in a couple of different views.</P><P></P><P>The first is a straight text box that will display the percent through the quarter.</P><P></P><P>The second is for conditional formatting. I have a pivot table with each month's performance compared to budget. I would to have conditional formatting for the percent through the month for each month. Therefore, since March is 100% over, anything over 100% is green. However May is only 3% through the month therefore anything over 3% would be green. </P><P></P><P>Thanks for your help!</P></BODY></HTML> Wed, 01 May 2013 12:35:50 GMT 2013-05-01T12:35:50Z Percent through the month/quarter https://community.qlik.com/t5/QlikView/Percent-through-the-month-quarter/m-p/417102#M485048 <HTML><HEAD></HEAD><BODY><P>I need help with calculating the percent through the month and quarter in a couple of different views.</P><P></P><P>The first is a straight text box that will display the percent through the quarter.</P><P></P><P>The second is for conditional formatting. I have a pivot table with each month's performance compared to budget. I would to have conditional formatting for the percent through the month for each month. Therefore, since March is 100% over, anything over 100% is green. However May is only 3% through the month therefore anything over 3% would be green. </P><P></P><P>Thanks for your help!</P></BODY></HTML> Wed, 01 May 2013 12:35:50 GMT https://community.qlik.com/t5/QlikView/Percent-through-the-month-quarter/m-p/417102#M485048 2013-05-01T12:35:50Z