Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

First day of each month


Hi, I have a set of date in this format "dd/mm/yyyy" for every month of the year 2015.

screenshot.png

I need to show the first day of each month of the year in QlikSense.

Can someone help me to write the expression?

2 Replies
Highlighted

May be create a field like this:

LOAD Date,

          MonthStart(Date) as MonthStartDate

....

or use a filter expression

MonthStart(Date)

Highlighted
Specialist
Specialist

Hi

try this  for the  FIRST Day

Day(MonthSTART(DATA))


Last day


Day(MonthEnd(DATA))