how to find every month 4th date in qlikview - Qlik Community

qlikapple · ‎2018-11-01

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

PrashantSangle · ‎2018-11-01

try below

Date(monthstart(dateFieldName)+4)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

qlikapple · ‎2018-11-01

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 · ‎2018-11-01

Try this

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

Instead of Today() you can put your date field

Anil_Babu_Samineni · ‎2018-11-01

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

];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Mark_Little · ‎2018-11-01

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