Creating Buckets (on size and selling price)

[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 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:	Indicator	Minimum	Maximum	Label
TV	SIZE	0	26	26" ↓
TV	SIZE	26	32	32"
TV	SIZE	32	38	37"
TV	SIZE	38	43	40" - 42"
TV	SIZE	43	52	46" - 50"
TV	SIZE	52	58	55"
TV	SIZE	58	999	60"↑
Mobile	Price	0	75	ULC (<$75)
Mobile	Price	75	150	Low ($75-$150)
Mobile	Price	150	300	Mid ($150-$300)
Mobile	Price	300	500	High($300-$500)
Mobile	Price	500	600	Super High($500-$600)
Mobile	Price	600	9999	Ultra High($600 and above)
Tablets	Price	0	100	ULC (<$100)
Tablets	Price	100	200	Low ($100-$200)
Tablets	Price	200	300	Mid ($200-$300)
Tablets	Price	300	400	High($300-$400)
Tablets	Price	400	500	Super High($400-$500)
Tablets	Price	500	9999	Ultra High($500 and above)

[israrkhan]

yes it is...

because yesterday when i created,  it was being moderated, and moderator took 14 hours to approve the post. so at that time i tried to create another,

now i tried to delete the topic, but it says "unauthorized" even it is created by me..

so the qlik community in not working as it must me...

[israrkhan]

Dear Jonathan,

if you could help me on the topic,

will appreciate it..

i will try to remove the duplicate post..sure..

but dont know, some time why they hold the post for the moderator, even with simple text...

Many Thanks

[jonathandienst]

No problem

[kavita25]

what is the calculation of %??

[israrkhan]

if size is dimension, size is in Model Table..size bucket is in Bucket table..

% is sum(Price)/ sum(total price)..

[jonathandienst]

I see one data problem after looking at your Excel file. You have two bucket ranges for price - 1 for Mobile and another for Tablets. But there is no indication any of the other tabs of the Prodcut B (Product sp?) values, so I don't know which bucket range to use.

[israrkhan]

Dear Jonathan.

thank you..

please you can add new column into excel, as new indicator.

i have access to database, i will create same column in my database here...

[jonathandienst]

Post an updated Excel file when you are done.

[Digvijay_Singh]

Hi,

I am not seeing Product against some models used in transaction, tried to verify in excel as well. Can you revert why it is so?

Please see attached QVW, I was just trying to understand data better. Also Product Code and Product having different format, which one you wanted to use for analysis.

[israrkhan]

if you look in to first sheet(Bucket) you can see Product B column, which will be linked to Product Column in Product sheet(second sheet).

please ignore the product column (first column) in Bucket Sheet..

Many Thanks