2 Replies Latest reply: Jun 11, 2012 2:23 AM by trash123 RSS

    link list boxes

      Hi,

      here it's the problem I have...

      I have attached an excel file which shows the three tables I have (just an example with dummy data).

      Start_time is the link between "table values" and "table price".

      id_values is the link between "table details" and "table values".

      What I want is a chart with on the x-axis the "start_time" and on the y-axis the expression (price*quantity) only for items that have type=A

      The problem is that when I select type A in the list box showing prices no value gets selected, on the contrary if I select a start_time but not a type then the correct value is highlighted in the prices list box.

       

       

      Thanks in advance!

      Michel

        • link list boxes
          Eva Polini

          Could you send your QVW?

            • Re: link list boxes

              This is my code:

               

              Load type, message_id as id_values;

              SQL SELECT type, message_id

              FROM details;

               

               

              Load *, message_id as id_quantity, Day(start_time) as day, Month(start_time) as month,

              Year(start_time) as year, Mid(date(start_time,'dd-mm-yyyy hh:mm'),11) as time;

              SQL SELECT *

              FROM price

              order by start_time;

               

               

              Load *, message_id as id_values, Day(start_time) as day, Month(start_time) as month,

              Year(start_time) as year, Mid(date(start_time,'dd-mm-yyyy hh:mm'),11) as time;

              SQL SELECT *

              FROM values

              order by start_time;