First day of each month

[#1]

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

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

Can someone help me to write the expression?

[sunny_talwar]

May be create a field like this:

LOAD Date,

          MonthStart(Date) as MonthStartDate

....

or use a filter expression

MonthStart(Date)

[Anonymous]

Hi

try this  for the  FIRST Day

Day(MonthSTART(DATA))

Last day

Day(MonthEnd(DATA))