Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sahajaqlik
Contributor

how to find every month 4th date in qlikview

how to find every month 4th for each month  in qlikview

5 Replies

Re: how to find every month 4th date in qlikview

try below

Date(monthstart(dateFieldName)+4)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
sahajaqlik
Contributor

Re: how to find every month 4th date in qlikview

is that datefield name is date or what

if i keep the date also i am not getting Nov 4th.

I am getting nov 1st only

prma7799
Honored Contributor III

Re: how to find every month 4th date in qlikview

Try this

=Date(monthstart(Today())+3)

Instead of Today() you can put your date field

Re: how to find every month 4th date in qlikview

From below data, What you are expecting?

Load * Inline [

DateField

02-10-2018

03-10-2018

04-10-2018

07-10-2018

01-11-2018

02-11-2018

03-11-2018

04-11-2018

];

Life is so rich, and we need to respect to the life !!!
mark6505
Valued Contributor III

Re: how to find every month 4th date in qlikview

HI,

With the limited information i would guess you would want something like the below.

IF( DAY(Date) = 4,1,0) as 4thDayFlag,

This would give you a flag you can use to pick out any date starting the 4th.

Mark

Community Browser