topic Problem in Between Slab in QlikView https://community.qlik.com/t5/QlikView/Problem-in-Between-Slab/m-p/851918#M1008964 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; My Data Format is</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 287px;"><TBODY><TR><TD class="xl63" height="17" width="137">CUSTOMERTARGETID</TD><TD class="xl63" style="border-left: none;" width="84">FROMSLABMT</TD><TD class="xl63" style="border-left: none;" width="66">TOSLABMT</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1100</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-D</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1100</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2600</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-E</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2600</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100000</TD></TR></TBODY></TABLE><P>and one column in Quantity when total quantity between 0 to 50 then CLUB-A when 50-300 then CLUB-B as so on how to write script on text Object Please Suggest Attached Referance given Bellow..</P></BODY></HTML> Wed, 29 Apr 2015 15:38:10 GMT vijayit43 2015-04-29T15:38:10Z Problem in Between Slab https://community.qlik.com/t5/QlikView/Problem-in-Between-Slab/m-p/851918#M1008964 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; My Data Format is</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 287px;"><TBODY><TR><TD class="xl63" height="17" width="137">CUSTOMERTARGETID</TD><TD class="xl63" style="border-left: none;" width="84">FROMSLABMT</TD><TD class="xl63" style="border-left: none;" width="66">TOSLABMT</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1100</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-D</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1100</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2600</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">CLUB-E</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2600</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100000</TD></TR></TBODY></TABLE><P>and one column in Quantity when total quantity between 0 to 50 then CLUB-A when 50-300 then CLUB-B as so on how to write script on text Object Please Suggest Attached Referance given Bellow..</P></BODY></HTML> Wed, 29 Apr 2015 15:38:10 GMT https://community.qlik.com/t5/QlikView/Problem-in-Between-Slab/m-p/851918#M1008964 vijayit43 2015-04-29T15:38:10Z Re: Problem in Between Slab https://community.qlik.com/t5/QlikView/Problem-in-Between-Slab/m-p/851919#M1008966 <HTML><HEAD></HEAD><BODY><P>Try the <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">IntervalMatch</A>‌ function.<SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P></BODY></HTML> Wed, 29 Apr 2015 15:57:07 GMT https://community.qlik.com/t5/QlikView/Problem-in-Between-Slab/m-p/851919#M1008966 Gysbert_Wassenaar 2015-04-29T15:57:07Z