topic Re: Month end between in QlikView

Month end between

arsenal1983 — Mon, 22 Feb 2016 08:56:20 GMT

Hi,

I have data with two date columns (DATE_A, DATE_B).

I need to flag records, which brakes a month (at least one month end between those two dates).

Any ideas?

Re: Month end between

alexandros17 — Mon, 22 Feb 2016 09:00:31 GMT

Could you please explain with more details what you need?

Thanks

Re: Month end between

senpradip007 — Mon, 22 Feb 2016 09:01:45 GMT

Try like:

if(DATE_A - DATE_B >=30, 1, 0) as Flag

From

<Data Source>;

Re: Month end between

kaushiknsolanki — Mon, 22 Feb 2016 09:03:28 GMT

Hi,

You can use this logic to flag them.

=if(Date2 >= MonthEnd(Date1),1,0)

Regards,

Kaushik Solanki

Re: Month end between

jagan — Mon, 22 Feb 2016 09:10:14 GMT

Hi,

Try like this

LOAD

if(Fabs(DATE_A - DATE_B) >=30, 1, 0) as Flag

FROM DataSource;

LOAD

if(MonthName(DATE_A) <> MonthName(DATE_B), 1, 0) as Flag

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Month end between

Anonymous — Mon, 22 Feb 2016 09:17:13 GMT

by using the set anlaysis it implemented

Re: Month end between

sunny_talwar — Mon, 22 Feb 2016 10:05:02 GMT

Another one could be:

Table:

LOAD *,

If(Floor(MonthEnd(DATE_B)) > Floor(MonthEnd(DATE_A)), 1, 0) as Flag;

LOAD * Inline [

DATE_A, DATE_B

01/20/2016, 01/30/2016

02/12/2016, 03/03/2016

];