topic Save interval match table in load script in QlikView https://community.qlik.com/t5/QlikView/Save-interval-match-table-in-load-script/m-p/314019#M707386 <HTML><HEAD></HEAD><BODY><P>We manage a customer desk, where several customers come and leave:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="144" style="border: 1px solid #000000; text-align: center; width: 282px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Come</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Leave</STRONG></SPAN></TH></TR><TR><TD>100</TD><TD>103</TD></TR><TR><TD>105</TD><TD>107</TD></TR><TR><TD>106</TD><TD>110</TD></TR><TR><TD>112</TD><TD>114</TD></TR></TBODY></TABLE><P></P><P>Now we want to match the ships with a calendar,</P><P>such as</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="144" style="border: 1px solid #000000; text-align: center; width: 282px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Come</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Leave</STRONG></SPAN></TH></TR><TR><TD>100</TD><TD>100</TD><TD>103</TD></TR><TR><TD>101</TD><TD>100</TD><TD>103</TD></TR><TR><TD>102</TD><TD>100</TD><TD>103</TD></TR><TR><TD>103</TD><TD>100</TD><TD>103</TD></TR><TR><TD>104</TD><TD>-</TD><TD>-</TD></TR><TR><TD>105</TD><TD>105</TD><TD>107</TD></TR><TR><TD>106</TD><TD>105</TD><TD>107</TD></TR><TR><TD>106</TD><TD>106</TD><TD>110</TD></TR><TR><TD>107</TD><TD>105</TD><TD>107</TD></TR><TR><TD>108</TD><TD>106</TD><TD>110</TD></TR><TR><TD>109</TD><TD>106</TD><TD>110</TD></TR><TR><TD>110</TD><TD>106</TD><TD>110</TD></TR><TR><TD>111</TD><TD>-</TD><TD>-</TD></TR><TR><TD>112</TD><TD>112</TD><TD>113</TD></TR></TBODY></TABLE><P></P><P>This is usually, what reslts ot of an IntervalMatch. But we would like to have it <STRONG>available right after the load script</STRONG>?</P><P></P><P><SPAN>The solution presented there is not working though: </SPAN><A _jive_internal="true" href="https://community.qlik.com/message/122414#122414">http://community.qlik.com/message/122414#122414</A></P><P></P><P>Does anyone have an idea how to achieve the desired result?</P><P></P><P>Best,</P><P>Jonas</P></BODY></HTML> Thu, 23 Feb 2012 16:10:33 GMT 2012-02-23T16:10:33Z Save interval match table in load script https://community.qlik.com/t5/QlikView/Save-interval-match-table-in-load-script/m-p/314019#M707386 <HTML><HEAD></HEAD><BODY><P>We manage a customer desk, where several customers come and leave:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="144" style="border: 1px solid #000000; text-align: center; width: 282px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Come</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Leave</STRONG></SPAN></TH></TR><TR><TD>100</TD><TD>103</TD></TR><TR><TD>105</TD><TD>107</TD></TR><TR><TD>106</TD><TD>110</TD></TR><TR><TD>112</TD><TD>114</TD></TR></TBODY></TABLE><P></P><P>Now we want to match the ships with a calendar,</P><P>such as</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="144" style="border: 1px solid #000000; text-align: center; width: 282px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Come</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Time_Leave</STRONG></SPAN></TH></TR><TR><TD>100</TD><TD>100</TD><TD>103</TD></TR><TR><TD>101</TD><TD>100</TD><TD>103</TD></TR><TR><TD>102</TD><TD>100</TD><TD>103</TD></TR><TR><TD>103</TD><TD>100</TD><TD>103</TD></TR><TR><TD>104</TD><TD>-</TD><TD>-</TD></TR><TR><TD>105</TD><TD>105</TD><TD>107</TD></TR><TR><TD>106</TD><TD>105</TD><TD>107</TD></TR><TR><TD>106</TD><TD>106</TD><TD>110</TD></TR><TR><TD>107</TD><TD>105</TD><TD>107</TD></TR><TR><TD>108</TD><TD>106</TD><TD>110</TD></TR><TR><TD>109</TD><TD>106</TD><TD>110</TD></TR><TR><TD>110</TD><TD>106</TD><TD>110</TD></TR><TR><TD>111</TD><TD>-</TD><TD>-</TD></TR><TR><TD>112</TD><TD>112</TD><TD>113</TD></TR></TBODY></TABLE><P></P><P>This is usually, what reslts ot of an IntervalMatch. But we would like to have it <STRONG>available right after the load script</STRONG>?</P><P></P><P><SPAN>The solution presented there is not working though: </SPAN><A _jive_internal="true" href="https://community.qlik.com/message/122414#122414">http://community.qlik.com/message/122414#122414</A></P><P></P><P>Does anyone have an idea how to achieve the desired result?</P><P></P><P>Best,</P><P>Jonas</P></BODY></HTML> Thu, 23 Feb 2012 16:10:33 GMT https://community.qlik.com/t5/QlikView/Save-interval-match-table-in-load-script/m-p/314019#M707386 2012-02-23T16:10:33Z