topic Re: Intervals in QlikView

Intervals

Anonymous — Fri, 22 Nov 2013 14:58:32 GMT

Dear all,

I was wondering how to use intervals instead individual values.

I've a ticket table which contains all the support tickets and their solution time (like this)

TICKET CATEGORY SOLUTION TIME (Hours)

123 A 4

231 A 8

34454 B 15

3422 A 8

777 b 4

66 b 20

I would display the table using intervals , like this:

Nr.TICKET SOLUTION TIME

2 0 <= 5

2 >5 <= 10

1 > 10 <= 15

1 > 15

HOw can I do it ?

Help please

Thanks in advance

Re: Intervals

datanibbler — Fri, 22 Nov 2013 15:02:21 GMT

Hi bibopipo,

try like this:

IntervalMatch (Url_Rest)
LOAD * INLINE [
Start2, End2

0, 5

6, 10

11, 15

16, 40

];

(With IntervalMatch() you need closed intervals, that's why I put the upper limit for the last interval at 40 - you could use any value, but there has to be a limit)

HTH

Best regards,

DataNibbler

Re: Intervals

bbi_mba_76 — Fri, 22 Nov 2013 15:06:06 GMT

Hi,

you could try the class function

class(expression, interval [ , label [ , offset ]])

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

So, in a chart you could add =Class([SOLUTION TIME (Hours)],5) as calculated dimension and Count(TICKET) as expression

Re: Intervals

Fri, 22 Nov 2013 15:32:25 GMT

Hi,

I would solve it in the script en handle it from there.

Table:

load * inline [

TICKET, CATEGORY, TIME

123,A,4

231,A,8

34454,B,15

3422,A,8

777,b,4

66,b,20

];

Sorttable:

Load

TICKET,

CATEGORY,

TIME,

if(TIME < 5, 1, if(TIME >5 and TIME <=10, 2, if(TIME >10 and TIME <=15, 3, 4 ))) as SolTimeCode

Resident Table;

Drop table Table;

Regards,

Gerrit

Re: Intervals

Anonymous — Fri, 22 Nov 2013 15:57:34 GMT

THANKS !!!