topic Overlapping periods in QlikView https://community.qlik.com/t5/QlikView/Overlapping-periods/m-p/134465#M20172 <HTML><HEAD></HEAD><BODY><P>Dear colleagues! </P><P>I've got some problems with connecting data:<BR />1. Managers and sales. Example:</P><P>Manager_history:</P><TABLE border="1" class="jiveBorder" height="274" style="border: 1px solid rgb(0, 0, 0); width: 282px; height: 274px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manager</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Object</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manager_date_appointment</STRONG></TH></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;"><P>26.10.2017</P></TD></TR><TR><TD style="padding: 2px;">Nick</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">03.07.2018</TD></TR><TR><TD style="padding: 2px;">Jack</TD><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">01.08.2018</TD></TR><TR><TD style="padding: 2px;">Ivan</TD><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">15.10.2017</TD></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">01.03.2018</TD></TR><TR><TD style="padding: 2px;">Jack</TD><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">13.07.2018</TD></TR></TBODY></TABLE><P>Sales:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Object</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales_date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales</TH></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">27.10.2017</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">30.11.2017</TD><TD style="padding: 2px;">150</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">05.08.2018</TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">06.08.2018</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">01.09.2018</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">13.10.2018</TD><TD style="padding: 2px;">340</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">17.10.2017</TD><TD style="padding: 2px;">170</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">19.10.2017</TD><TD style="padding: 2px;"><P>300</P></TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">02.04.2018</TD><TD style="padding: 2px;">650</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">03.05.2018</TD><TD style="padding: 2px;">322</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">11.08.2018</TD><TD style="padding: 2px;">432</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">10.10.2018</TD><TD style="padding: 2px;">600</TD></TR></TBODY></TABLE><P></P><P>How can i get sales in the context of managers? (needed result below)</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manager</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sum_sales</TH></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">100+150+650+322=1222</TD></TR><TR><TD style="padding: 2px;">Nick</TD><TD style="padding: 2px;">300+200=500</TD></TR><TR><TD style="padding: 2px;">Jack</TD><TD style="padding: 2px;">500+340+432+600=1872</TD></TR><TR><TD style="padding: 2px;">Ivan</TD><TD style="padding: 2px;">170+300=470</TD></TR></TBODY></TABLE><P></P><P>2. Building stage and sales. The same data + stages of objects with interval dates such as:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Object</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Building_stage</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stage_start</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stage_end</STRONG></TH></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">Foundation</TD><TD style="padding: 2px;">01.01.2016</TD><TD style="padding: 2px;">04.08.2018</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">Roof</TD><TD style="padding: 2px;">05.08.2018</TD><TD style="padding: 2px;">01.10.2019</TD></TR><TR><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">Construction of floors</TD><TD style="padding: 2px;">01.01.2017</TD><TD style="padding: 2px;">20.10.2018</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Foundation</SPAN></TD><TD style="padding: 2px;">01.05.2016</TD><TD style="padding: 2px;">13.12.2017</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Construction of floors</SPAN></TD><TD style="padding: 2px;">14.12.2017</TD><TD style="padding: 2px;">01.05.2018</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">Roof</TD><TD style="padding: 2px;">02.05.2018</TD><TD style="padding: 2px;">11.11.2019</TD></TR></TBODY></TABLE><P></P><P>The idea of needed results is the same (<SPAN style="font-size: 13.3333px;">sales in the context of building stages):</SPAN></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; font-size: 13.3333px; text-align: center; background-color: #6690bc;">Building_stage</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; font-size: 13.3333px; text-align: center; background-color: #6690bc;">Sum_sales</SPAN></TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Foundation</SPAN></TD><TD style="padding: 2px;">100+150+170+300=720</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Construction of floors</SPAN></TD><TD style="padding: 2px;">500+340+650=1490</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Roof</SPAN></TD><TD style="padding: 2px;">300+200+322+432+600=1854</TD></TR></TBODY></TABLE><P></P><P>I'll be grateful for all advice. Thanks a lot. </P></BODY></HTML> Wed, 24 Oct 2018 14:52:31 GMT Anonymous 2018-10-24T14:52:31Z Overlapping periods https://community.qlik.com/t5/QlikView/Overlapping-periods/m-p/134465#M20172 <HTML><HEAD></HEAD><BODY><P>Dear colleagues! </P><P>I've got some problems with connecting data:<BR />1. Managers and sales. Example:</P><P>Manager_history:</P><TABLE border="1" class="jiveBorder" height="274" style="border: 1px solid rgb(0, 0, 0); width: 282px; height: 274px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manager</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Object</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manager_date_appointment</STRONG></TH></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;"><P>26.10.2017</P></TD></TR><TR><TD style="padding: 2px;">Nick</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">03.07.2018</TD></TR><TR><TD style="padding: 2px;">Jack</TD><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">01.08.2018</TD></TR><TR><TD style="padding: 2px;">Ivan</TD><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">15.10.2017</TD></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">01.03.2018</TD></TR><TR><TD style="padding: 2px;">Jack</TD><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">13.07.2018</TD></TR></TBODY></TABLE><P>Sales:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Object</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales_date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales</TH></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">27.10.2017</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">30.11.2017</TD><TD style="padding: 2px;">150</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">05.08.2018</TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">06.08.2018</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">01.09.2018</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">13.10.2018</TD><TD style="padding: 2px;">340</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">17.10.2017</TD><TD style="padding: 2px;">170</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">19.10.2017</TD><TD style="padding: 2px;"><P>300</P></TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">02.04.2018</TD><TD style="padding: 2px;">650</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">03.05.2018</TD><TD style="padding: 2px;">322</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">11.08.2018</TD><TD style="padding: 2px;">432</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">10.10.2018</TD><TD style="padding: 2px;">600</TD></TR></TBODY></TABLE><P></P><P>How can i get sales in the context of managers? (needed result below)</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manager</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sum_sales</TH></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">100+150+650+322=1222</TD></TR><TR><TD style="padding: 2px;">Nick</TD><TD style="padding: 2px;">300+200=500</TD></TR><TR><TD style="padding: 2px;">Jack</TD><TD style="padding: 2px;">500+340+432+600=1872</TD></TR><TR><TD style="padding: 2px;">Ivan</TD><TD style="padding: 2px;">170+300=470</TD></TR></TBODY></TABLE><P></P><P>2. Building stage and sales. The same data + stages of objects with interval dates such as:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Object</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Building_stage</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stage_start</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stage_end</STRONG></TH></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">Foundation</TD><TD style="padding: 2px;">01.01.2016</TD><TD style="padding: 2px;">04.08.2018</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">Roof</TD><TD style="padding: 2px;">05.08.2018</TD><TD style="padding: 2px;">01.10.2019</TD></TR><TR><TD style="padding: 2px;">124</TD><TD style="padding: 2px;">Construction of floors</TD><TD style="padding: 2px;">01.01.2017</TD><TD style="padding: 2px;">20.10.2018</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Foundation</SPAN></TD><TD style="padding: 2px;">01.05.2016</TD><TD style="padding: 2px;">13.12.2017</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Construction of floors</SPAN></TD><TD style="padding: 2px;">14.12.2017</TD><TD style="padding: 2px;">01.05.2018</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">Roof</TD><TD style="padding: 2px;">02.05.2018</TD><TD style="padding: 2px;">11.11.2019</TD></TR></TBODY></TABLE><P></P><P>The idea of needed results is the same (<SPAN style="font-size: 13.3333px;">sales in the context of building stages):</SPAN></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; font-size: 13.3333px; text-align: center; background-color: #6690bc;">Building_stage</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; font-size: 13.3333px; text-align: center; background-color: #6690bc;">Sum_sales</SPAN></TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Foundation</SPAN></TD><TD style="padding: 2px;">100+150+170+300=720</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Construction of floors</SPAN></TD><TD style="padding: 2px;">500+340+650=1490</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Roof</SPAN></TD><TD style="padding: 2px;">300+200+322+432+600=1854</TD></TR></TBODY></TABLE><P></P><P>I'll be grateful for all advice. Thanks a lot. </P></BODY></HTML> Wed, 24 Oct 2018 14:52:31 GMT https://community.qlik.com/t5/QlikView/Overlapping-periods/m-p/134465#M20172 Anonymous 2018-10-24T14:52:31Z