topic Re: Budget vs. bookings in App Development

topic Re: Budget vs. bookings in App Development https://community.qlik.com/t5/App-Development/Budget-vs-bookings/m-p/951495#M13501 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Please test it with the data in the appendix . It come out completely different values</SPAN></P></BODY></HTML> Mon, 07 Dec 2015 10:47:54 GMT marcoebner 2015-12-07T10:47:54Z Budget vs. bookings https://community.qlik.com/t5/App-Development/Budget-vs-bookings/m-p/951494#M13500 <HTML><HEAD></HEAD><BODY><P>Hallo and greets from Hamburg. </P><P></P><P></P><P>I have Projekts with Budget planning:</P><P></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="374"><TBODY><TR><TD class="xl64" height="20" width="105">Projektnummer</TD><TD class="xl64" style="border-left: none;" width="132">Projektbezeichnung</TD><TD class="xl65" style="border-left: none;" width="63">Planwert</TD><TD class="xl64" style="border-left: none;" width="74">Plandatum</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">Eins</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100,00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">01.01.2016</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">Eins</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">800,00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">01.02.2016</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">Eins</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300,00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">01.03.2016</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">Zwei</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">400,00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">01.01.2016</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">Zwei</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">500,00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">01.02.2016</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">Zwei</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">600,00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">01.03.2016</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">3</TD><TD class="xl64" style="border-top: none; border-left: none;">Drei</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">700,00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">01.04.2016</TD></TR></TBODY></TABLE><P></P><P>And bookings für the real Costs.</P><P></P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="274"><TBODY><TR><TD class="xl65" height="20" width="105">Projektnummer</TD><TD class="xl65" style="border-left: none;" width="106">Buchungsdatum</TD><TD class="xl66" style="border-left: none;" width="63">Betrag</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.05.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.05.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">9,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">13,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">14,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.05.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">12,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">18,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20.01.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">21,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">19,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30.03.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20,00</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15.05.2016</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20,00</TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to achieve following:</P><P>Plandatum = the max Datum per Year, per Projekt</P><P>Planwert = Value from the "max Datum per year, per Projekt</P><P>Buchungen = Summary value per Projekt per same year Plandatum</P><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 345px;"><TBODY><TR><TD height="20" width="105">Projektnummer</TD><TD width="80">Plandatum</TD><TD width="80">Planwert</TD><TD width="80">Buchungen</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl65">01.03.2016</TD><TD class="xl66">  300,00   </TD><TD class="xl66">  13,00   </TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl65">01.02.2016</TD><TD class="xl66">  500,00   </TD><TD class="xl66">  36,00   </TD></TR><TR><TD align="right" height="20">3</TD><TD align="right" class="xl65">01.04.2016</TD><TD class="xl66">  700,00   </TD><TD class="xl66">159,00   </TD></TR></TBODY></TABLE></BODY></HTML> Fri, 04 Dec 2015 09:49:07 GMT https://community.qlik.com/t5/App-Development/Budget-vs-bookings/m-p/951494#M13500 marcoebner 2015-12-04T09:49:07Z Re: Budget vs. bookings https://community.qlik.com/t5/App-Development/Budget-vs-bookings/m-p/951495#M13501 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Please test it with the data in the appendix . It come out completely different values</SPAN></P></BODY></HTML> Mon, 07 Dec 2015 10:47:54 GMT https://community.qlik.com/t5/App-Development/Budget-vs-bookings/m-p/951495#M13501 marcoebner 2015-12-07T10:47:54Z