Creating Buckets (on size and selling price)

[israrkhan]

Hi Guys,

i have to create bucket for product sold, and product size,

i have a product table, product table is linked to Model Table, and Model table linked to Transaction table. in the transaction table i have my quantity and selling price.

i have defined the buckets range in the below excel file. the product column in the below excel is linked to my Product column in product table. i dont have product column in the transaction table, so how to do it.

kindly help me, how to achieve this, in the load script or front end.. idea please..

i would appreciate your help.

Bucket Table:

Prodcut:	Indicator	Minimum	Maximum	Label
TV	SIZE	0	26	26" ↓
TV	SIZE	26	32	32"
TV	SIZE	32	38	37"
TV	SIZE	38	43	40" - 42"
TV	SIZE	43	52	46" - 50"
TV	SIZE	52	58	55"
TV	SIZE	58	999	60"↑
Mobile	Price	0	75	ULC (<$75)
Mobile	Price	75	150	Low ($75-$150)
Mobile	Price	150	300	Mid ($150-$300)
Mobile	Price	300	500	High($300-$500)
Mobile	Price	500	600	Super High($500-$600)
Mobile	Price	600	9999	Ultra High($600 and above)
Tablets	Price	0	100	ULC (<$100)
Tablets	Price	100	200	Low ($100-$200)
Tablets	Price	200	300	Mid ($200-$300)
Tablets	Price	300	400	High($300-$400)
Tablets	Price	400	500	Super High($400-$500)
Tablets	Price	500	9999	Ultra High($500 and above)

[maximiliano_vel]

You can use Interval Match between your Bucket Table and Transaccion Table

JOIN ([Bucket Table]) IntervalMatch (Qty) LOAD Minimum, Maximum RESIDENT [Bucket Table];

The Qty is your Producto Quantity in your transaction table

[maxgro]

I think (just an idea) you have to add the Product (using Product --> Model --> Transaction if possible) to the fact table

and then use interval match (or 2 interval match, one for Price / selling Price, the other for Size / Quantiy) to join the Product in fact table with the excel Product

[israrkhan]

Dear Massimo,

i really tried, but could not get any solutions yet.

because my Bucket Table is linked to Product Table, and product table is linked to Model table, model table linked to Transaction table.

i have Quantity and Price in Transaction table, and I have size in Model table.

i was thinking to to ask you or Gysbert to help me..

i can explain you well, or can share a sample data, if you willing to help me...

i will really appreciate it ..

Many Thanks

[israrkhan]

Hi

i tried this one

left join(Sellout) IntervalMatch(SellOut.PRICE)

LOAD

      Minimum,

      Maximum

from abc.

but it giving me wrong data...see in the image

[qlikviewwizard]

Hi IsrarKhan

Can you share your sample QVW with the data to demonstrate your issue? Thank you.

[israrkhan]

Thank you..

if i attache AN EXCEL file, than moderator will take one day to approve...

any how, i am attaching an excel file with data, in the next reply, may be i got lucky...

[israrkhan]

see the attached file, with sample data, all Tables,

my table are linked as below..

Bucket --> Product--> Model-->Transaction.

i have Quantity and Price In Transaction table. and Bucket range of price in Bucket table.

i have size in Model Table, and Bucket range of size in Bucket table....

kindly let me know, if any thing is not clear...

Many Thanks

[israrkhan]

expected result... as shown in attached image in pie chart...

[jonathandienst]

This topic is a duplicate of Re: Bucket (based on selling price and size of product)

Please do not repeat or repost duplicates of a question.