Bucket (based on selling price and size of product)

[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 excel file. the product column in the excel is linked to my Product column in product table. i dont have product column in the transaction table, in transaction table i have Model_Code, 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.

product Bucket excel is attached..

[Gysbert_Wassenaar]

Guessing on what you posted and your excel file I'd say you're looking for the IntervalMatch function. See this blog post: https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

And you seem to have intervals per product so you need to use the extended syntax (see the help file or Re: IntervalMatch Multiplying Records).

[israrkhan]

Hi Gysbert,

Thank you for reply.

i read about interval match, but still not clear how to use interval match in my case.

if i explain better or provide you sample data, can you please give me sample..?

Many Thanks

[MarcoWedel]

please post some sample data from each of your tables and your expected result.

thanks

regards

Marco

[israrkhan]

dear Marco,

kindly find the excel file attached...with all table.

tables are linked as Bucket--> Product--> Model --> Transaction

quantity and price are in transaction table, and i want to see Bucket wise quantity sold, and price.

if the product is tv, than i want to see how much i sold on diffident bucket size,

many thanks

!

[israrkhan]

expected result...

[jonathandienst]

This topic is a duplicate of Creating Buckets (on size and selling price)‌

Please do not repeat or repost duplicates of a question.