topic Generate YTD, QTD, MTD, WTD in QlikView https://community.qlik.com/t5/QlikView/Generate-YTD-QTD-MTD-WTD/m-p/350366#M129831 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I am getting data by WeekEndingDate........&nbsp; How to&nbsp; genrate YTD, QTD, MTD, WTD(week to date)&nbsp; from WeekEndingDate</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border-width: initial; border-color: initial; border-image: initial; border-style: none;"><TBODY><TR><TD style="border-image: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: windowtext; border-style: solid;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">WeekEndingDate</SPAN></P>&nbsp; </TD><TD style="border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; border-left-width: initial; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-left-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">ActualSales</SPAN></P>&nbsp; </TD><TD style="border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; border-left-width: initial; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-left-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">PlanSales </SPAN></P>&nbsp; </TD></TR><TR><TD style="border-top-width: initial; border-top-color: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">01/08/2012</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">1000</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;">1200</P>&nbsp; </TD></TR><TR><TD style="border-top-width: initial; border-top-color: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">05/13/2012</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">1300</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;">1400</P>&nbsp; </TD></TR><TR><TD style="border-top-width: initial; border-top-color: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">05/20/2012</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;">1500</P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 14 May 2012 14:35:01 GMT 2012-05-14T14:35:01Z Generate YTD, QTD, MTD, WTD https://community.qlik.com/t5/QlikView/Generate-YTD-QTD-MTD-WTD/m-p/350366#M129831 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I am getting data by WeekEndingDate........&nbsp; How to&nbsp; genrate YTD, QTD, MTD, WTD(week to date)&nbsp; from WeekEndingDate</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border-width: initial; border-color: initial; border-image: initial; border-style: none;"><TBODY><TR><TD style="border-image: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: windowtext; border-style: solid;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">WeekEndingDate</SPAN></P>&nbsp; </TD><TD style="border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; border-left-width: initial; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-left-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">ActualSales</SPAN></P>&nbsp; </TD><TD style="border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; border-left-width: initial; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-left-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">PlanSales </SPAN></P>&nbsp; </TD></TR><TR><TD style="border-top-width: initial; border-top-color: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">01/08/2012</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">1000</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;">1200</P>&nbsp; </TD></TR><TR><TD style="border-top-width: initial; border-top-color: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">05/13/2012</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">1300</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;">1400</P>&nbsp; </TD></TR><TR><TD style="border-top-width: initial; border-top-color: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;"><SPAN style="font-family: Arial, sans-serif; font-size: 10pt;">05/20/2012</SPAN></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P></P>&nbsp; </TD><TD style="border-top-width: initial; border-top-color: initial; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-color: windowtext; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt;" valign="top" width="213"> <P style="margin-bottom: 0.0001pt;">1500</P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 14 May 2012 14:35:01 GMT https://community.qlik.com/t5/QlikView/Generate-YTD-QTD-MTD-WTD/m-p/350366#M129831 2012-05-14T14:35:01Z