topic New table with ranges in QlikView

New table with ranges

Fri, 20 Apr 2012 12:25:59 GMT

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!!

New table with ranges

Jason_Michaelides — Fri, 20 Apr 2012 12:31:29 GMT

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

Hope this helps,

Jason

Re: New table with ranges

CELAMBARASAN — Fri, 20 Apr 2012 12:33:41 GMT

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

New table with ranges

Fri, 20 Apr 2012 14:04:57 GMT

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.

New table with ranges

CELAMBARASAN — Fri, 20 Apr 2012 15:24:23 GMT

Hi,

As per your requirement

start is CountLow

end is CountHigh

Time is Counts to match between start and end.

Celambarasan

New table with ranges

Fri, 20 Apr 2012 15:29:53 GMT

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

Thank u!