Discussion Board for collaboration related to QlikView App Development.
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.
|TV||SIZE||38||43||40" - 42"|
|TV||SIZE||43||52||46" - 50"|
|Mobile||Price||600||9999||Ultra High($600 and above)|
|Tablets||Price||500||9999||Ultra High($500 and above)|
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
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
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 ..
i tried this one
left join(Sellout) IntervalMatch(SellOut.PRICE)
but it giving me wrong data...see in the image
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...
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...
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.