Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Valued Contributor 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
Highlighted
Partner
Partner

Re: Creating Buckets (on size and selling price)

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

Highlighted
MVP
MVP

Re: Creating Buckets (on size and selling price)

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

Highlighted
Valued Contributor II

Re: Creating Buckets (on size and selling price)

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

Highlighted
Valued Contributor II

Re: Creating Buckets (on size and selling price)

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

Highlighted
Honored Contributor II

Re: Creating Buckets (on size and selling price)

Hi IsrarKhan

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

Highlighted
Valued Contributor II

Re: Creating Buckets (on size and selling price)

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

Highlighted
Valued Contributor II

Re: Creating Buckets (on size and selling price)

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

Highlighted
Valued Contributor II

Re: Creating Buckets (on size and selling price)

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

Highlighted
MVP
MVP

Re: Creating Buckets (on size and selling price)

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