topic link list boxes in QlikView

link list boxes

Fri, 08 Jun 2012 14:40:23 GMT

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

Fri, 08 Jun 2012 14:55:48 GMT

Could you send your QVW?

Re: link list boxes

Fri, 08 Jun 2012 15:06:18 GMT

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;