topic Re: Inline interval dimensions in QlikView

Inline interval dimensions

Tue, 06 May 2014 01:30:35 GMT

Hi Everyone

I have below fields.

Load *,

as no_of_days_to_solve // gives me number of days which is enddate - start date.

How can i create dimension that shows

Case took more then 15 days

Case solved in 15 days

case solved in 10 days

case solved in 5-10 days

case solved within 5 days

LOAD [Ticket Number],

[Requestor Name],

[Support Group],

[Call Summary],

[Call Status],

[Call Severity],

[Call Type],

[Create Date],

Year ([Create Date]) as year,

month ([Create Date]) as Month,

day([Create Date]) as day,

[Closed Date]

FROM

Re: Inline interval dimensions

SergeyMak — Tue, 06 May 2014 01:49:50 GMT

Try to use IF

IF(no_of_days_to_solve<=5, '0-5 days',

no_of_days_to_solve>5 and no_of_days_to_solve<=10, '6-10 days',

no_of_days_to_solve>10 and no_of_days_to_solve<=15, '11-15 days',

'16+ days'

) AS YourDimension

Re: Inline interval dimensions

Tue, 06 May 2014 04:05:40 GMT

Thanks Sergey

I am getting syntax error after second statement where we are testing for 5 to 10.

no_of_days_to_solve>5 and no_of_days_to_solve<=10 // syntax error start from comma , '6-10 days',

Re: Inline interval dimensions

SergeyMak — Tue, 06 May 2014 04:09:33 GMT

sorry... my mistake

IF(no_of_days_to_solve<=5, '0-5 days',

IF(no_of_days_to_solve>5 and no_of_days_to_solve<=10, '6-10 days',

IF(no_of_days_to_solve>10 and no_of_days_to_solve<=15, '11-15 days',

'16+ days'

))) AS YourDimension

Re: Inline interval dimensions

tresB — Tue, 06 May 2014 04:18:28 GMT

I recommend class().

Re: Inline interval dimensions

SunilChauhan — Tue, 06 May 2014 04:20:58 GMT

use class function like below

Class(no_of_days_to_solve,5,'no_of_days_to_solve') as fieldname

and use in dimension

hope this helps

Re: Inline interval dimensions

Tue, 06 May 2014 15:38:03 GMT

How to use Class () function for below example.

IF(no_of_days_to_solve<=5, '0-5 days',

IF(no_of_days_to_solve>5 and no_of_days_to_solve<=10, '6-10 days',

IF(no_of_days_to_solve>10 and no_of_days_to_solve<=15, '11-15 days',

'16+ days'

))) AS YourDimension

Re: Inline interval dimensions

SergeyMak — Wed, 07 May 2014 01:08:02 GMT

IF(RIGHT(Class(no_of_days_to_solve,5),2)>15, '16+', Class(no_of_days_to_solve,5)) AS YourDimension

Or you can use directly in the chart as calculated dimension

IF(RIGHT(Class(no_of_days_to_solve,5),2)>15, '16+', Class(no_of_days_to_solve,5))