Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
israrkhan
Specialist II
Specialist II

Creating Buckets (on size and selling price)

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:IndicatorMinimumMaximumLabel
TVSIZE02626" ↓
TVSIZE263232"
TVSIZE323837"
TVSIZE384340" - 42"
TVSIZE435246" - 50"
TVSIZE525855"
TVSIZE5899960"↑
MobilePrice075ULC (<$75)
MobilePrice75150Low ($75-$150)
MobilePrice150300Mid ($150-$300)
MobilePrice300500High($300-$500)
MobilePrice500600Super High($500-$600)
MobilePrice6009999Ultra High($600 and above)
TabletsPrice0100ULC (<$100)
TabletsPrice100200Low ($100-$200)
TabletsPrice200300Mid ($200-$300)
TabletsPrice300400High($300-$400)
TabletsPrice400500Super High($400-$500)
TabletsPrice5009999Ultra High($500 and above)
20 Replies
maximiliano_vel
Partner - Creator III
Partner - Creator III

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
MVP
MVP

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
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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

11.png

qlikviewwizard
Master II
Master II

Hi IsrarKhan

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

israrkhan
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein