Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you send your QVW?
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;