New table with ranges

[#1]

Hello,

i have this table with numbers of counts, in ranges:

CountClass - CountLow - CountHight

     Sales         10010          10012

     Salaries      20030          20033

I need to create a new table, with de CountClass, and all de Counts between de values Low and High.

CountClass   -   Count

Sales               10010

Sales               10011

Sales               10012

Salaries            20030

Salaries            20031

Salaries            20032

Salaries            20033

How can i do it?

Thanks!!

[Jason_Michaelides]

Look at IntervalMatch() in the F1 help, the reference manual and the forum.

Hope this helps,

Jason

[CELAMBARASAN · Accepted solution]

Hi,

     Why you need to do like this.I think you need to link this to another Field in th name count.    

     I hope intervalmatch(Count) function will help you to do that(for more info look at help file).

OrderLog
Start	End	Order
01:00	03:35	A
02:30	07:58	B
03:04	10:27	C
07:23	11:43	D

EventLog
Time	Event	Comment
00:00	0	Start of shift 1
01:18	1	Line stop
02:23	2	Line restart 50%
04:15	3	Line speed 100%
08:00	4	Start of shift 2
11:43	5	End of production

First load the two tables as usual, then link the field Time to the time intervals defined by the fields Start and End:

Select * from OrderLog;

Select * from Eventlog;

IntervalMatch ( Time ) select Start, End from OrderLog;

The following table box could now be created in QlikView:

Tablebox
Time	Event	Comment	Order	Start	End
00:00	0	Start of shift 1	-	-	-
01:18	1	Line stop	A	01:00	03:35
02:23	2	Line restart 50%	A	01:00	03:35
04:15	3	Line speed 100%	B	02:30	07:58
04:15	3	Line speed 100%	C	03:04	10:27
08:00	4	Start of shift 2	C	03:04	10:27
08:00	4	Start of shift 2	D	07:23	11:43
11:43	5	End of production	D	07:23	11:43

Celambarasan

[#4]

Thank you both!

But the sentence,

IntervalMatch ( Time ) select Start, End from OrderLog;

the fields "Start" and "End" are in gray. Also the comand "from".

I dont know what is happening.

[CELAMBARASAN]

Hi,

     As per your requirement

     start is CountLow

     end is CountHigh

     Time is Counts to match between start and end.

Celambarasan

[#6]

I replace "select" with "load" and work fine...

Thank u!