How can I use Qlikview to create Pricing Buckets based on Retail prices for products?

[#1]

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?

Example

Item	Retail Price	Price Bucket
Product A	$10	$10-19.99
Product B	$12	$20-29.99
Product C	$20	$20-29.99
Product D	$35	$30-39.99
Product E	$15	$10-19.99
Product F	$25	$20-29.99

Pricing Bucket	Product Offering Count	Sold (Units)
$10-19.99	2	150
$20-29.99	3	650
$30-39.99	1	20
Grand Total	6	820

[maxgro · Accepted solution]

use class function

result

script

b:

load * inline [

Item, Retail Price, Price Bucket, Unit

Product A, $10, $10-19.99, 50

Product B, $12, $20-29.99, 50

Product C, $20, $20-29.99, 300

Product D, $35, $30-39.99, 20

Product E, $15, $10-19.99, 50

Product F, $25, $20-29.99, 350

];

[#3]

Thank you Massimo. I found the Class Function to work perfectly.