topic Re: Next Day in QlikView

Next Day

brindlogcool — Tue, 21 Aug 2012 14:07:36 GMT

Hi,

Is there any Qlikview function equal to NEXT_DAY function in oracle i need to find the first monday of every month after the 5 working days

SunilChauhan — Tue, 21 Aug 2012 14:14:13 GMT

use

date(datefield+1)

brindlogcool — Tue, 21 Aug 2012 14:18:58 GMT

Hi Sunil,

So you are saying Date function in Qlikview is equal to Next_day function. Can you please provide an example?

SunilChauhan — Tue, 21 Aug 2012 14:29:06 GMT

I am not sayaing date function is equal to next day

after adding + 1 it will will equal to next day

ex:

=Date('01-01-2012'+1) results in n 02-01-2012

hope this helps

brindlogcool — Tue, 21 Aug 2012 14:37:45 GMT

Hi Sunil,

I was looking for different solution. NEXT_DAY in oracle will give you the below result.

SELECT TO_CHAR(NEXT_DAY('01-SEP-97','Monday'),'MM/DD/YYYY HH:MM:SS AM') "Next_Day" from DUAL;

It will give the next monday from the given date.

I am looking for the similar function in qlikview.

Thanks

daveamz — Tue, 21 Aug 2012 14:47:19 GMT

Hi,

See weekstart () function.

Weekstart (01-aug-2012,1) will return 06-aug-2012.

Regards,

David

brindlogcool — Tue, 21 Aug 2012 15:03:11 GMT

Thanks David , this is what i was looking for...