Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

];

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

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