Column based on selection

Mon, 02 Apr 2012 13:01:29 GMT

I have few data as per enclosed file.

Worksheets

Supplier showing all supplier I have

A showing data for supplier A

B showing data for supplier B

C showing data for supplier C

Final showing final table I need

If I will select Supplier B from supplier table (worksheet supplier), my final table should be as below

i.e. no price will appear for all parts in Supplier B column so that they will not be calculated while getting Min price.

Column 6 will automatically show Data for Supplier B (as selected above and ignored column in getting Min price) and % difference will be calculated in column 7 (% Diff)

i.e. (Min-Supplier B)/Supplier B

Part	Supplier A	Supplier B	Supplier C	Min	Supplier B	% Diff
X	10		20	10	40	-75.00%
Y	20			20
Z	30		15	15	50	-70.00%

Regards,

Manish Kachhia

Column based on selection

Tue, 03 Apr 2012 07:38:46 GMT

Can anyone please reply?

Column based on selection

Tue, 03 Apr 2012 08:31:44 GMT

Thanks to all who has read this discussion.

I tried and solved myself.

topic Column based on selection in QlikView

Column based on selection

Column based on selection

Column based on selection