topic Re: Bucket (based on selling price and size of product) in QlikView

Bucket (based on selling price and size of product)

israrkhan — Tue, 11 Aug 2015 05:40:14 GMT

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

Re: Bucket (based on selling price and size of product)

Gysbert_Wassenaar — Tue, 11 Aug 2015 08:01:19 GMT

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

Re: Bucket (based on selling price and size of product)

israrkhan — Tue, 11 Aug 2015 14:05:58 GMT

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

Re: Bucket (based on selling price and size of product)

MarcoWedel — Tue, 11 Aug 2015 21:19:09 GMT

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

thanks

regards

Marco

Re: Bucket (based on selling price and size of product)

israrkhan — Wed, 12 Aug 2015 03:42:22 GMT

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

Re: Bucket (based on selling price and size of product)

israrkhan — Wed, 12 Aug 2015 06:57:52 GMT

expected result...

Re: Bucket (based on selling price and size of product)

jonathandienst — Wed, 12 Aug 2015 07:08:52 GMT

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

Please do not repeat or repost duplicates of a question.