Need Rows Data Based on selection in List Box

Sat, 10 Mar 2012 10:40:45 GMT

Dear All,

I want to prepare a quotation based on data available.

Though there are 10000+ rows and 20+ columns for PriceTable, only few of them shown.

PriceTable:

BasicData:

From above BasicData, I need Freight and Margin both should be shown separately as list box properties with LED selection type.

Once I select one data from each list box, respective column in my FinalTable (i.e. Freight and Margin) will be appeared as data selected.

i.e. if I select 3% freight and 10% margin, FinalTable will be having all rows with 3% freight and 10% margin.

My Quotation should be as below.

Need Final Table should be as chart & straight table.

FinalTable:

Thanks and looking forward for your quick response.

Regards,

Manish Kachhia

CELAMBARASAN — Sat, 10 Mar 2012 10:55:05 GMT

Hi,

Have a straight table

Dimension:ITEM

Expressions:

=RangeMin([Supplier 01],[Supplier 02],[Supplier 03],[Supplier 04]) for Min(£)

=Freight for Freight

=Margin for Margin

(Column(0) - Line wise) *(1+Fright%)/(1-Margin%) for Quotation (£)

Celambarasan

Sat, 10 Mar 2012 11:07:36 GMT

Oh... so simple...

Thanks for your help...

topic Need Rows Data Based on selection in List Box in QlikView