The easiest ways to solve it osis to transform your data this way:
Product, Supplier, Price
Apple, Supplier01, 10
Apple, Supplier02, 20
Then you could use Product, Supplier as dimensions,
and simply =min(Price) for minimum price and =FirstSortedValue(Supplier, Price) for supplier name.
(read the manual for firstsortedvalue(), as it works if prices are different)
Just use CrossTable() statement before your load statement (look at help).
Thanks for your response.
Please check attachment.
I have found solution using if statement, but it’s very problematic as I have more than 100 supplier and can’t write 100 times IF sentence.
If there any other way to get solution.
Also, in this example, Cheapest Supplier for Orange should be Supplier01, Supplier03 both.
Is your spreadsheet with 100 suppliers in the same format, i.e only one row per product and all suppliers in columns?
You should try to get the data in the form Product, Supplier, Price. One row for every product-supplier-price combination.
Just as Whiteline said above. It's best if you can do that before you load the data in qlikview.