topic Re:Time in QlikView

Re:Time

Chanty4u — Wed, 08 Jul 2015 07:42:08 GMT

hi ,

Need help.

PFA

my reuirment is from ORDER_BOOK field i want above 60min between10&30min,between 30&45min

using if Else condition ony nt usng interval match fun

Thank you

suresh

Re:Time

MK_QSL — Wed, 08 Jul 2015 07:45:06 GMT

These 60 min, 10-30 min are duration?

Provide some more info.

Re:Time

Chanty4u — Wed, 08 Jul 2015 07:50:10 GMT

hi manish

yes duration only.

Re:Time

MK_QSL — Wed, 08 Jul 2015 07:51:29 GMT

My question is how your will get those duration?

Have you calculated in script?

are they field values or difference of two timestamps?

Re:Time

Chanty4u — Wed, 08 Jul 2015 07:55:13 GMT

in script part only done..no same timestamps.

just i wan the condition usng if else

Re:Time

MK_QSL — Wed, 08 Jul 2015 08:05:55 GMT

If(Duration < 10, '<10',

If(Duration >= 10 and Duration < 30, '10-30',

If(Duration >= 30 and Duration < 45, '30-45',

'>=45')))

Aggr(If(Duration < 10, '<10',

If(Duration >= 10 and Duration < 30, '10-30',

If(Duration >= 30 and Duration < 45, '30-45',

'>=45'))), ORDER_BOOK)

Re:Time

sasiparupudi1 — Wed, 08 Jul 2015 08:06:15 GMT

Please provide sample data

Re:Time

Chanty4u — Wed, 08 Jul 2015 08:12:15 GMT

i want in pivot table

PFA

Re:Time

jagan — Wed, 08 Jul 2015 08:13:40 GMT

Hi,

You can use If condition for this, IntervalMatch() is not suitable for this scenario. Try like below

LOAD

If(Duration <10, '<10',

If(Duration >= 10 and Duration < 30, '10-30',

If(Duration >= 30 and Duration < 45, '30-45',

'>=45'))) AS TimeRange

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re:Time

jagan — Wed, 08 Jul 2015 08:18:24 GMT

Hi,

Try this script

LOAD SI_NUMBER,

HEADER_ID,

LOCATION_NAME,

REQ_CREATION_DATE,

ORD_CREATION_DATE,

OSN_TIME,

REQ_TO_ORD_CREATE_TIME_MINS,

ORDER_BOOK_TO_OSN_TIME,

TAT,

If(ORDER_BOOK_TO_OSN_TIME <10, '<10',

If(ORDER_BOOK_TO_OSN_TIME >= 10 and ORDER_BOOK_TO_OSN_TIME < 30, '10-30',

If(ORDER_BOOK_TO_OSN_TIME >= 30 and ORDER_BOOK_TO_OSN_TIME < 45, '30-45',

'>=45'))) AS TimeRange

FROM

(ooxml, embedded labels, table is [between 10 & 30 minutes]);

Regards,

Jagan.

Re:Time

sasiparupudi1 — Wed, 08 Jul 2015 08:37:26 GMT

if (ORDER_BOOK_TO_OSN_TIME<10,'less than 10 minutes',if(ORDER_BOOK_TO_OSN_TIME>=10 and ORDER_BOOK_TO_OSN_TIME<=30,'between 10 & 30 minutes',if(ORDER_BOOK_TO_OSN_TIME>30 and ORDER_BOOK_TO_OSN_TIME<=45,'between 30 & 45 minutes',if(ORDER_BOOK_TO_OSN_TIME>45 and ORDER_BOOK_TO_OSN_TIME<=60,'between 45 & 60 minutes',if(ORDER_BOOK_TO_OSN_TIME>=60 ,'above 60 minutes'))))) as Interval