topic Re: YTD in QlikView https://community.qlik.com/t5/QlikView/YTD/m-p/1697739#M726833 <P>I believe Set Analysis is likely the best way to go, check the following Design Blog post, hopefully they will help get you on the right track:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822</A></P><P>There is a link to the Primer post on this one, so you can review that one too if need be, hopefully this helps.</P><P>Regards,<BR />Brett</P> Wed, 29 Apr 2020 13:42:19 GMT Brett_Bleess 2020-04-29T13:42:19Z YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1691093#M726831 <P>May I know how to create YTD for my data set below?</P><P>I don't have a date format like, 31/1/2019.</P><P>Am new to Qlik, thanks for your help!</P><P>&nbsp;</P><TABLE width="832"><TBODY><TR><TD width="64">&nbsp;</TD><TD width="768"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prior Year</STRONG></TD></TR><TR><TD>&nbsp;</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD><TD>Act</TD></TR><TR><TD><STRONG>Account</STRONG></TD><TD><STRONG>M01</STRONG></TD><TD><STRONG>M02</STRONG></TD><TD><STRONG>M03</STRONG></TD><TD><STRONG>M04</STRONG></TD><TD><STRONG>M05</STRONG></TD><TD><STRONG>M06</STRONG></TD><TD><STRONG>M07</STRONG></TD><TD><STRONG>M08</STRONG></TD><TD><STRONG>M09</STRONG></TD><TD><STRONG>M10</STRONG></TD><TD><STRONG>M11</STRONG></TD><TD><STRONG>M12</STRONG></TD></TR><TR><TD>AAA</TD><TD>27.09</TD><TD>42.00</TD><TD>29.37</TD><TD>25.95</TD><TD>27.25</TD><TD>15.51</TD><TD>31.34</TD><TD>21.16</TD><TD>13.00</TD><TD>29.21</TD><TD>30.72</TD><TD>51.62</TD></TR><TR><TD>BBB</TD><TD>10.68</TD><TD>11.10</TD><TD>12.68</TD><TD>11.00</TD><TD>15.48</TD><TD>9.00</TD><TD>13.58</TD><TD>14.35</TD><TD>13.87</TD><TD>12.74</TD><TD>16.67</TD><TD>12.76</TD></TR><TR><TD>CCC</TD><TD>(0.00)</TD><TD>0.00</TD><TD>(0.00)</TD><TD>0.00</TD><TD>0.00</TD><TD>(0.00)</TD><TD>0.00</TD><TD>(0.00)</TD><TD>(0.00)</TD><TD>(0.00)</TD><TD>0.00</TD><TD>(0.00)</TD></TR><TR><TD>DDD</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD></TR><TR><TD>EEE</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD><TD>0.00</TD></TR><TR><TD>FFF</TD><TD>0.16</TD><TD>0.40</TD><TD>0.21</TD><TD>0.21</TD><TD>0.20</TD><TD>0.19</TD><TD>0.16</TD><TD>0.17</TD><TD>0.15</TD><TD>0.08</TD><TD>0.02</TD><TD>0.21</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 00:53:53 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1691093#M726831 Rcp_17 2024-11-16T00:53:53Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1691094#M726832 <P>Actually, the row "Prior Year" covers all from M01 to M12.</P> Mon, 06 Apr 2020 06:37:40 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1691094#M726832 Rcp_17 2020-04-06T06:37:40Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1697739#M726833 <P>I believe Set Analysis is likely the best way to go, check the following Design Blog post, hopefully they will help get you on the right track:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822</A></P><P>There is a link to the Primer post on this one, so you can review that one too if need be, hopefully this helps.</P><P>Regards,<BR />Brett</P> Wed, 29 Apr 2020 13:42:19 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1697739#M726833 Brett_Bleess 2020-04-29T13:42:19Z