topic Script for Quantities with Intervals in QlikView https://community.qlik.com/t5/QlikView/Script-for-Quantities-with-Intervals/m-p/1411011#M801701 <HTML><HEAD></HEAD><BODY><P>hi everyone,</P><P></P><P>can any 1 explain the script with example to find the price for number of quantity sold, if quantity have an intervals</P><P>for exam, the quantity sold is 5, i have interval like</P><P><SPAN style="color: black; font-family: 'Times New Roman', serif; font-size: 12pt;">For Product , 1 to 3 quantities costs 100rs and quantities 4 to 15 costs 110rs</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="color: black; font-family: 'Times New Roman', serif; font-size: 12pt;">Hence for first 5 quantity sold the total price is 520rs</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vignesh_s 2020-11-25T16:16:04Z Script for Quantities with Intervals https://community.qlik.com/t5/QlikView/Script-for-Quantities-with-Intervals/m-p/1411011#M801701 <HTML><HEAD></HEAD><BODY><P>hi everyone,</P><P></P><P>can any 1 explain the script with example to find the price for number of quantity sold, if quantity have an intervals</P><P>for exam, the quantity sold is 5, i have interval like</P><P><SPAN style="color: black; font-family: 'Times New Roman', serif; font-size: 12pt;">For Product , 1 to 3 quantities costs 100rs and quantities 4 to 15 costs 110rs</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="color: black; font-family: 'Times New Roman', serif; font-size: 12pt;">Hence for first 5 quantity sold the total price is 520rs</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Script-for-Quantities-with-Intervals/m-p/1411011#M801701 vignesh_s 2020-11-25T16:16:04Z Re: hi every1, https://community.qlik.com/t5/QlikView/Script-for-Quantities-with-Intervals/m-p/1411012#M801702 <HTML><HEAD></HEAD><BODY><P><STRONG style="color: black; font-size: 10.0pt; font-family: 'Times New Roman','serif';"><BR /></STRONG></P><P><STRONG style="color: black; font-size: 10.0pt; font-family: 'Times New Roman','serif';">cont.... of the above<BR /></STRONG></P><P><STRONG style="color: black; font-size: 10.0pt; font-family: 'Times New Roman','serif';">(3*100)+(2*110) = 520)</STRONG></P><P><STRONG style="color: black; font-size: 10.0pt; font-family: 'Times New Roman','serif';"><BR /></STRONG></P></BODY></HTML> Fri, 17 Nov 2017 06:49:49 GMT https://community.qlik.com/t5/QlikView/Script-for-Quantities-with-Intervals/m-p/1411012#M801702 vignesh_s 2017-11-17T06:49:49Z