Interval match based on our selection

jagannalla — Thu, 20 Sep 2012 14:29:00 GMT

Hello,

I've two tables:

T1:

Start	End	Customer
2012-09-19 10:16:04.000	2012-09-18 11:00:00.0000000	A
2012-09-19 11:16:04.000	2012-09-18 12:00:00.0000000	B
2012-09-19 12:16:04.000	2012-09-18 13:00:00.0000000	C
2012-09-19 13:16:04.000	2012-09-18 14:00:00.0000000	D

T2:

Name	Interval	Value
A1	2012-09-19 10:20:04.000	10
A1	2012-09-19 10:31:04.000	20
A1	2012-09-19 10:40:04.000	30
A1	2012-09-19 10:50:04.000	40
B1	2012-09-19 11:20:04.000	10
B1	2012-09-19 11:31:04.000	20
B1	2012-09-19 11:40:04.000	30
B1	2012-09-19 11:50:04.000	40
C1	2012-09-19 12:20:04.000	10
C2	2012-09-19 12:31:04.000	20
C3	2012-09-19 12:40:04.000	30
C4	2012-09-19 12:50:04.000	40
A1	2012-09-19 12:20:04.000	100
A1	2012-09-19 12:31:04.000	101
A1	2012-09-19 12:40:04.000	102
A1	2012-09-19 12:50:04.000	103

- To link this two tables I've taken another table i.e

T3:

Name	Customer
A1	A
B1	B
C1	C
D1	D

- Now there is a link between all the tables. Now I'll take line chart with dimension with Interval and Value as expression.

- If i select A from Customer listbox i need to see the Value which are existing for this Customer and also the range which is existing for this customer from the first table.

For eg:

A customer has the start and end time in T1 table is 2012-09-19 10:16:04.000 to 2012-09-18 11:00:00.0000000. So I need to see in the line chart only this range.

But If you see the range is existing for this A customer is 2012-09-19 10:16:04.000 to 2012-09-18 11:00:00.0000000 and also 2012-09-19 12:20:04.000 to 2012-09-19 12:50:04.000.

I don't want to see in the line chart the second range which is existing for this Customer.

For your reference I'm attaching sample file along with data.

Re: Interval match based on our selection

jagannalla — Thu, 20 Sep 2012 14:49:44 GMT

Sorry the above file is wrong data. Plz see lates file.

topic Re: Interval match based on our selection in QlikView

Interval match based on our selection

Re: Interval match based on our selection