1 Reply Latest reply: Jul 9, 2012 11:34 AM by John Shepherd RSS

    How do I link a list box (Currency - USD & Local) to charts and tables already in a dashboard that has Gross/Net Premium & Brokerage for a number of countries?

      How do I link a list box (Currency - USD & Local) to charts and tables already in a dashboard that has Gross/Net Premium & Brokerage for a number of countries?

       

      The Gross/Net Premium & Brokerage figures are in 'Base' (local currency for each country) and 'USD' which have been converted using monthly exchange rates which I upload via an Excel spreadsheet every month. I downloaded the Asset Management demo of this site, which is similar to what I need (in regards to currency logic) but cannot seem to be able to use the same logic in my dashboard.

       

      Attached Asset Management QlikView demo for a reference.