topic Re: Set Analysis for 'best of' calculation in QlikView

Set Analysis for 'best of' calculation

supriyabiware — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can someone help me writing a set analysis formula for Best of Calculation?

e.g. = Supplier 1 - sells Product 1 for 10 €

Supplier 2 - sells Product 1 for 15 €

Supplier 3 - sells Product 1 for 12 €...... i have this data for many products many suppliers.

i want to calculate sum(selling price) for Product 1 - but selling price should include #Best of Bid# .. in above case sum(selling price)=10€ for Product 1

This formula would be applied on chart Supplier Vs Selling price (For specific Product - which is listbox filter)

I understand that it should be min(selling price forEach Product) - but i am not sure of set analysis formula here.

Thanks

Supriya

Re: Set Analysis for 'best of' calculation

MK9885 — Mon, 09 Oct 2017 20:14:32 GMT

=Sum({<Product_Price= {"$(=Min(Product_Price))"}>}Product_Price)

this would give you minimum price of the product

Not sure if above one is correct?

Can you post a sample data?

Re: Set Analysis for 'best of' calculation

supriyabiware — Wed, 11 Oct 2017 07:30:52 GMT

Hello Aehman,

Something like sum(minimum of Product Price in one Product)

1. when i select one product the text box should show min price whereas the chart (supplier vs price) should show the minimum price for each supplier.

2. when no product is selected text box should show sum(minimum of Product Price in one Product) and chart(supplier vs price) should show all suppliers with minimum price for each product

catch here is - multiple suppliers have same price chart wants to display all, but text box should pick one min value.

Thanks

Supriya

Re: Set Analysis for 'best of' calculation

tresB — Wed, 11 Oct 2017 08:33:18 GMT

May be this?

Sum(Aggr(Min(ProductPrice),Product))

If this doesn't help, try to share your sample qvw.

Re: Set Analysis for 'best of' calculation

Kushal_Chawda — Wed, 11 Oct 2017 09:08:51 GMT

try below

Sum(Aggr(Min(ProductPrice),Product,Supplier))

Re: Set Analysis for 'best of' calculation

supriyabiware — Wed, 11 Oct 2017 11:13:26 GMT

Thanks this worked perfect! i guess i was thinking something complex because of the requirement