topic Re: Projections in QlikView https://community.qlik.com/t5/QlikView/Projections/m-p/1347023#M414436 <HTML><HEAD></HEAD><BODY><P>what is expression for %submitted?</P></BODY></HTML> Fri, 07 Jul 2017 13:35:47 GMT Kushal_Chawda 2017-07-07T13:35:47Z Projections https://community.qlik.com/t5/QlikView/Projections/m-p/1347022#M414435 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm looking for some actual data and projected data on a line graph. </P><P></P><P>What I currently have for actual data is -</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 197px;"><TBODY><TR><TD height="68" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: black windowtext windowtext black;" width="80"><SPAN style="color: #000000;">Revenue Period</SPAN></TD><TD style="border: 0px windowtext; border-image: none;" width="117"><SPAN style="color: #000000;">% Submitted in 20days</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/05</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">54.6%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/06</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">51.0%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/07</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">48.9%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/08</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">45.8%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/09</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">49.0%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/10</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">51.3%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/11</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">64.1%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/12</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">56.5%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/01</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">59.5%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/02</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">49.6%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/03</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">58.1%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/04</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">62.9%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/05</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">61.2%</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/06</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">57.4%</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">2017/07</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/08</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/09</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">2017/10</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/11</SPAN></TD></TR><TR><TD height="17" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/12</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>And I want to project 2017/07 onwards&nbsp; My boss has produced some in excel based on 2016/05 + 2017/06 - 2016/06 for 2016/07 and so on for 2016/08, 09, 10, 11, 12.</P><P></P><P>Any suggestions would be great</P></BODY></HTML> Fri, 07 Jul 2017 13:24:46 GMT https://community.qlik.com/t5/QlikView/Projections/m-p/1347022#M414435 kevbrown 2017-07-07T13:24:46Z Re: Projections https://community.qlik.com/t5/QlikView/Projections/m-p/1347023#M414436 <HTML><HEAD></HEAD><BODY><P>what is expression for %submitted?</P></BODY></HTML> Fri, 07 Jul 2017 13:35:47 GMT https://community.qlik.com/t5/QlikView/Projections/m-p/1347023#M414436 Kushal_Chawda 2017-07-07T13:35:47Z Re: Projections https://community.qlik.com/t5/QlikView/Projections/m-p/1347024#M414437 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> So % is </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"><SPAN style="color: #000000;">Sum of Submitted within 20days</SPAN> / </SPAN><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;">Sum of Total</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> for each month</SPAN></P><P></P><P></P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 294px;"><TBODY><TR><TD height="68" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: black windowtext windowtext black;" width="66"><SPAN style="color: #000000;">Sum of Submitted within 20days</SPAN></TD><TD style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: black windowtext windowtext;" width="67"><SPAN style="color: #000000;">Sum of Invoiced in 30days </SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: black black windowtext windowtext;" width="81"><SPAN style="color: #000000;">Sum of Total </SPAN></TD><TD style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: black windowtext windowtext;" width="80"><SPAN style="color: #000000;">Revenue Period</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">567</SPAN></TD><TD align="right" style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: black windowtext windowtext;"><SPAN style="color: #000000;">279</SPAN></TD><TD align="right" style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: black black windowtext windowtext;"><SPAN style="color: #000000;">1038</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/05</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">783</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">286</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1536</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/06</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">776</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">451</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1588</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/07</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">877</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">382</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1916</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/08</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">866</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">411</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1769</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/09</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">746</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">478</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1454</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/10</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">1053</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">774</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1643</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/11</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">841</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">657</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1489</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2016/12</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">1096</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">753</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1841</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/01</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">680</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">491</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1371</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/02</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">778</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">612</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1338</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/03</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">598</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">495</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">951</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/04</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0px 0.5pt; border-style: none none none solid; border-color: windowtext windowtext windowtext black;"><SPAN style="color: #000000;">916</SPAN></TD><TD align="right" style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">621</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0px 0px; border-style: none solid none none; border-color: windowtext black windowtext windowtext;"><SPAN style="color: #000000;">1496</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/05</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0px 0.5pt 0.5pt; border-style: none none solid solid; border-color: windowtext windowtext black black;"><SPAN style="color: #000000;">912</SPAN></TD><TD align="right" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: windowtext windowtext black;"><SPAN style="color: #000000;">792</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext black black windowtext;"><SPAN style="color: #000000;">1589</SPAN></TD><TD style="border: 0px windowtext; border-image: none;"><SPAN style="color: #000000;">2017/06</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 07 Jul 2017 13:37:57 GMT https://community.qlik.com/t5/QlikView/Projections/m-p/1347024#M414437 kevbrown 2017-07-07T13:37:57Z Re: Projections https://community.qlik.com/t5/QlikView/Projections/m-p/1347025#M414438 <HTML><HEAD></HEAD><BODY><P>all this fields available in data or this (<SPAN style="font-size: 12pt; font-family: 'Times New Roman'; color: #000000;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit;">Sum of Submitted within 20days</SPAN> &amp; </SPAN><SPAN style="font-size: 12pt; font-family: 'Times New Roman'; color: #000000;">Sum of Total</SPAN><SPAN style="font-size: 12pt; font-family: 'Times New Roman'; color: #000000;"> for each month</SPAN>) is again calculation on front end? </P></BODY></HTML> Fri, 07 Jul 2017 13:40:21 GMT https://community.qlik.com/t5/QlikView/Projections/m-p/1347025#M414438 Kushal_Chawda 2017-07-07T13:40:21Z Re: Projections https://community.qlik.com/t5/QlikView/Projections/m-p/1347026#M414439 <HTML><HEAD></HEAD><BODY><P>Yes they're calulations</P></BODY></HTML> Fri, 07 Jul 2017 13:46:25 GMT https://community.qlik.com/t5/QlikView/Projections/m-p/1347026#M414439 kevbrown 2017-07-07T13:46:25Z Re: Projections https://community.qlik.com/t5/QlikView/Projections/m-p/1347027#M414440 <HTML><HEAD></HEAD><BODY><P>can you share the sample data?</P></BODY></HTML> Fri, 07 Jul 2017 15:37:30 GMT https://community.qlik.com/t5/QlikView/Projections/m-p/1347027#M414440 Kushal_Chawda 2017-07-07T15:37:30Z Re: Projections https://community.qlik.com/t5/QlikView/Projections/m-p/1347028#M414441 <HTML><HEAD></HEAD><BODY><P>Please Have a look at the QVW Example Application. Might be Helpful.</P></BODY></HTML> Fri, 07 Jul 2017 20:52:05 GMT https://community.qlik.com/t5/QlikView/Projections/m-p/1347028#M414441 Anonymous 2017-07-07T20:52:05Z