Discussion board where members can get started with QlikView.
how to find every month 4th for each month 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
Instead of Today() you can put your date field
From below data, What you are expecting?
Load * Inline [
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.