Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

showing profit based on selection

I have below data...

Customer NameCustomer CountryCustomer TotalSupplier NameSupplier CountryProductSupplier TotalProfit% Profit
CUST001Germany100SUPP001FranceOIL901010.00%
CUST003France300SUPP001FranceOIL2505016.67%
CUST002Germany200SUPP002GermanySOAP1505025.00%
CUST004USA400SUPP003ItalyEGGS380205.00%
CUST005Australia100SUPP004SpainRADIO802020.00%
CUST008France400SUPP004SpainRADIO30010025.00%
CUST006Italy200SUPP005USATV1752512.50%
CUST010Australia600SUPP005USATV5406010.00%
CUST007Germany300SUPP006IndiaPHONE2703010.00%
CUST009USA500SUPP006IndiaPHONE460408.00%


I need to show a profit table based on different selection. But want to make only one table.

My table should be displayed with below two columns.

Selection & PROFIT%....

where Selection could be any one from below which can be displayed as either list box, table box or multi box.

Customer Name

Customer Country

Supplier Name

Supplier Country

Product

Please help...

Regards,

Manish

10 Replies
Not applicable
Author

It's working perfectly. Thanks to all for your help.