Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

how to find every month 4th date in qlikview

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

5 Replies
PrashantSangle

try below

Date(monthstart(dateFieldName)+4)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
qlikapple
Creator
Creator
Author

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
Master III
Master III

Try this

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

Instead of Today() you can put your date field

Anil_Babu_Samineni

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)
mark6505
Partner
Partner

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