topic Re: How can I use Qlikview to create Pricing Buckets based on Retail prices for products? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-use-Qlikview-to-create-Pricing-Buckets-based-on-Retail/m-p/668317#M1073370 <HTML><HEAD></HEAD><BODY><P>Thank you Massimo. I found the Class Function to work perfectly.</P></BODY></HTML> Tue, 29 Jul 2014 21:13:49 GMT 2014-07-29T21:13:49Z How can I use Qlikview to create Pricing Buckets based on Retail prices for products? https://community.qlik.com/t5/QlikView/How-can-I-use-Qlikview-to-create-Pricing-Buckets-based-on-Retail/m-p/668315#M1073368 <HTML><HEAD></HEAD><BODY><P>I would like to group products by retail price buckets. I would like to show the importance of product groups based on pricing strategy. Is there a way for Qlikview to apply a Price Bucket that I determine? Or must this be done in the dataset feeding to Qlikview?</P><P></P><P>Example</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 227px;"><TBODY><TR><TD height="20" width="67">Item</TD><TD width="77">Retail Price</TD><TD style="color: #ff0000;" width="83">Price Bucket</TD></TR><TR><TD height="20">Product A</TD><TD align="right" class="xl63">$10 </TD><TD style="color: #ff0000;">$10-19.99</TD></TR><TR><TD height="20">Product B</TD><TD align="right" class="xl63">$12 </TD><TD style="color: #ff0000;">$20-29.99</TD></TR><TR><TD height="20">Product C</TD><TD align="right" class="xl63">$20 </TD><TD style="color: #ff0000;">$20-29.99</TD></TR><TR><TD height="20">Product D</TD><TD align="right" class="xl63">$35 </TD><TD style="color: #ff0000;">$30-39.99</TD></TR><TR><TD height="20">Product E</TD><TD align="right" class="xl63">$15 </TD><TD style="color: #ff0000;">$10-19.99</TD></TR><TR><TD height="20">Product F</TD><TD align="right" class="xl63">$25 </TD><TD style="color: #ff0000;">$20-29.99</TD></TR></TBODY></TABLE><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="308"><TBODY><TR><TD height="20" style="font-size: 11.0pt; color: black; font-weight: bold; font-family: Calibri; border-top: none; border-right: none; border-bottom: .5pt solid #95B3D7; border-left: none; background: #DCE6F1;" width="111">Pricing Bucket</TD><TD style="font-size: 11.0pt; color: black; font-weight: bold; font-family: Calibri; border-top: none; border-right: none; border-bottom: .5pt solid #95B3D7; border-left: none; background: #DCE6F1;" width="80">Product Offering Count</TD><TD style="font-size: 11.0pt; color: black; font-weight: bold; font-family: Calibri; border-top: none; border-right: none; border-bottom: .5pt solid #95B3D7; border-left: none; background: #DCE6F1;" width="117">Sold (Units)</TD></TR><TR><TD class="xl65" height="20">$10-19.99</TD><TD align="right">2</TD><TD align="right">150</TD></TR><TR><TD class="xl65" height="20">$20-29.99</TD><TD align="right">3</TD><TD align="right">650</TD></TR><TR><TD class="xl65" height="20">$30-39.99</TD><TD align="right">1</TD><TD align="right">20</TD></TR><TR><TD class="xl65" height="20" style="font-size: 11.0pt; color: black; font-weight: bold; font-family: Calibri; border-top: .5pt solid #95B3D7; border-right: none; border-bottom: none; border-left: none; background: #DCE6F1;">Grand Total</TD><TD align="right" style="font-size: 11.0pt; color: black; font-weight: bold; font-family: Calibri; border-top: .5pt solid #95B3D7; border-right: none; border-bottom: none; border-left: none; background: #DCE6F1;">6</TD><TD align="right" style="font-size: 11.0pt; color: black; font-weight: bold; font-family: Calibri; border-top: .5pt solid #95B3D7; border-right: none; border-bottom: none; border-left: none; background: #DCE6F1;">820</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 28 Jul 2014 20:24:02 GMT https://community.qlik.com/t5/QlikView/How-can-I-use-Qlikview-to-create-Pricing-Buckets-based-on-Retail/m-p/668315#M1073368 2014-07-28T20:24:02Z Re: How can I use Qlikview to create Pricing Buckets based on Retail prices for products? https://community.qlik.com/t5/QlikView/How-can-I-use-Qlikview-to-create-Pricing-Buckets-based-on-Retail/m-p/668316#M1073369 <HTML><HEAD></HEAD><BODY><P>use class function<STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>result</STRONG></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63282_1.png" style="width: auto; height: auto;" /></P><P></P><P><STRONG>script</STRONG></P><P>b:</P><P>load * inline [</P><P>Item, Retail Price, Price Bucket, Unit</P><P>Product A, $10, $10-19.99, 50</P><P>Product B, $12, $20-29.99, 50</P><P>Product C, $20, $20-29.99, 300</P><P>Product D, $35, $30-39.99, 20</P><P>Product E, $15, $10-19.99, 50 </P><P>Product F, $25, $20-29.99, 350</P><P>];</P></BODY></HTML> Mon, 28 Jul 2014 20:31:44 GMT https://community.qlik.com/t5/QlikView/How-can-I-use-Qlikview-to-create-Pricing-Buckets-based-on-Retail/m-p/668316#M1073369 maxgro 2014-07-28T20:31:44Z Re: How can I use Qlikview to create Pricing Buckets based on Retail prices for products? https://community.qlik.com/t5/QlikView/How-can-I-use-Qlikview-to-create-Pricing-Buckets-based-on-Retail/m-p/668317#M1073370 <HTML><HEAD></HEAD><BODY><P>Thank you Massimo. I found the Class Function to work perfectly.</P></BODY></HTML> Tue, 29 Jul 2014 21:13:49 GMT https://community.qlik.com/t5/QlikView/How-can-I-use-Qlikview-to-create-Pricing-Buckets-based-on-Retail/m-p/668317#M1073370 2014-07-29T21:13:49Z