topic backwards YTD formula in App Development

topic backwards YTD formula in App Development https://community.qlik.com/t5/App-Development/backwards-YTD-formula/m-p/1818466#M67075 <P>Hey there,</P><P>i have data which in the measure always shows the YTD value.</P><TABLE border="1"><TBODY><TR><TD>Position</TD><TD>Month</TD><TD>Value (YTD)2</TD></TR><TR><TD>Apple</TD><TD>1</TD><TD>10</TD></TR><TR><TD>Apple</TD><TD>2</TD><TD>15</TD></TR><TR><TD>Apple</TD><TD>3</TD><TD>25</TD></TR><TR><TD>Apple</TD><TD>4</TD><TD>30</TD></TR><TR><TD>Apple</TD><TD>5</TD><TD>40</TD></TR><TR><TD>Apple</TD><TD>6</TD><TD>50</TD></TR><TR><TD>...</TD><TD>....</TD><TD>...</TD></TR><TR><TD>....</TD><TD>....</TD><TD>....</TD></TR></TBODY></TABLE><P> </P><P>can I somehow use the set-analysis formula to calculate the monthly values?</P><P>January = 10</P><P>Febuary = 5</P><P>March = 10</P><P>April = 5</P><P>....</P><P>I don't want to calculate and create and data sets by scripting.</P><P>Thanks for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P> </P><P> </P> Tue, 29 Jun 2021 07:54:14 GMT Costa 2021-06-29T07:54:14Z backwards YTD formula https://community.qlik.com/t5/App-Development/backwards-YTD-formula/m-p/1818466#M67075 <P>Hey there,</P><P>i have data which in the measure always shows the YTD value.</P><TABLE border="1"><TBODY><TR><TD>Position</TD><TD>Month</TD><TD>Value (YTD)2</TD></TR><TR><TD>Apple</TD><TD>1</TD><TD>10</TD></TR><TR><TD>Apple</TD><TD>2</TD><TD>15</TD></TR><TR><TD>Apple</TD><TD>3</TD><TD>25</TD></TR><TR><TD>Apple</TD><TD>4</TD><TD>30</TD></TR><TR><TD>Apple</TD><TD>5</TD><TD>40</TD></TR><TR><TD>Apple</TD><TD>6</TD><TD>50</TD></TR><TR><TD>...</TD><TD>....</TD><TD>...</TD></TR><TR><TD>....</TD><TD>....</TD><TD>....</TD></TR></TBODY></TABLE><P> </P><P>can I somehow use the set-analysis formula to calculate the monthly values?</P><P>January = 10</P><P>Febuary = 5</P><P>March = 10</P><P>April = 5</P><P>....</P><P>I don't want to calculate and create and data sets by scripting.</P><P>Thanks for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P> </P><P> </P> Tue, 29 Jun 2021 07:54:14 GMT https://community.qlik.com/t5/App-Development/backwards-YTD-formula/m-p/1818466#M67075 Costa 2021-06-29T07:54:14Z