Date Range

dineshkumar — Thu, 08 Oct 2015 07:47:46 GMT

Hi all,

How can i arrange the date in date range like jan-feb, mar-apr, may-jun and so on... for the following dates

2014-12-31 06:23:46.480,

2015-04-01 04:34:51.893,

2015-04-05 08:33:49.000,

2015-04-08 04:14:01.190,

2015-04-08 09:16:12.570,

2015-04-08 09:26:32.623,

2015-04-09 07:44:57.520,

2015-04-09 07:48:54.040,

2015-04-09 10:41:21.247,

2015-04-09 12:33:02.633,

2015-04-09 12:34:06.483,

2015-05-09 12:37:28.697,

2015-06-09 12:39:06.563,

2015-07-09 12:40:35.963,

2015-07-10 03:06:26.247,

2015-07-10 04:39:57.587,

2015-07-10 06:11:12.137,

2015-07-10 07:46:29.457,

2015-08-10 07:53:05.203,

2015-08-10 08:06:23.187,

2015-08-10 10:39:05.533,

2015-08-10 11:31:07.877,

2015-08-11 03:47:55.707,

2015-09-12 12:51:41.133,

2015-09-15 08:29:49.723,

2015-09-15 08:49:41.887,

2015-09-15 16:55:54.187,

2015-09-16 09:07:17.297

Thanks & Regards

Dinesh

Re: Date Range

rubenmarin — Thu, 08 Oct 2015 13:01:21 GMT

Hi Dinesh, this script worked for me:

Data:

LOAD Date, If(Even(Month(Date)), Text(Month(AddMonths(Date, -1))) & '-' & Text(Month(Date)),

Text(Month(Date)) & '-' & Text(Month(AddMonths(Date, 1)))) as Range;

LOAD Date(Date#(Date, 'YYYY-MM-DD hh:mm:ss[.fff]')) as Date Inline [

Date

2014-12-31 06:23:46.480,

2015-04-01 04:34:51.893

2015-05-09 12:37:28.697

2015-06-09 12:39:06.563

2015-07-10 07:46:29.457

2015-08-10 07:53:05.203

2015-09-12 12:51:41.133

];

topic Date Range in QlikView

Date Range

Re: Date Range