https://community.qlik.com/t5/App-Development/Interval-Match-Sheet-with-variable-Input/m-p/1816911#M66870 <P>Hi,</P><P>Is there any possibility to do an interval match directly in the sheet (as a Master Element, for example), in combination with a Variable Input?</P><P>I have a table with Volume Based Discounts. Something similar to this:</P><TABLE><TBODY><TR><TD>Min QTY</TD><TD>Max QTY</TD><TD>Discount</TD></TR><TR><TD>0</TD><TD>100</TD><TD>0%</TD></TR><TR><TD>101</TD><TD>500</TD><TD>5%</TD></TR><TR><TD>501</TD><TD>1.000</TD><TD>10%</TD></TR><TR><TD>1.001</TD><TD>10.000.000.000</TD><TD>15%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In a sheet I have a variable input, where the user can input some quantities. I would like a master element which calculates the discount based on the new input quantities. Is that possible?</P><P>Thanks!</P> Tue, 22 Jun 2021 08:36:17 GMT charlie2 2021-06-22T08:36:17Z https://community.qlik.com/t5/App-Development/Interval-Match-Sheet-with-variable-Input/m-p/1816911#M66870 <P>Hi,</P><P>Is there any possibility to do an interval match directly in the sheet (as a Master Element, for example), in combination with a Variable Input?</P><P>I have a table with Volume Based Discounts. Something similar to this:</P><TABLE><TBODY><TR><TD>Min QTY</TD><TD>Max QTY</TD><TD>Discount</TD></TR><TR><TD>0</TD><TD>100</TD><TD>0%</TD></TR><TR><TD>101</TD><TD>500</TD><TD>5%</TD></TR><TR><TD>501</TD><TD>1.000</TD><TD>10%</TD></TR><TR><TD>1.001</TD><TD>10.000.000.000</TD><TD>15%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In a sheet I have a variable input, where the user can input some quantities. I would like a master element which calculates the discount based on the new input quantities. Is that possible?</P><P>Thanks!</P> Tue, 22 Jun 2021 08:36:17 GMT https://community.qlik.com/t5/App-Development/Interval-Match-Sheet-with-variable-Input/m-p/1816911#M66870 charlie2 2021-06-22T08:36:17Z