Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
philippr1991
Contributor II
Contributor II

Day number in month

Hi everyone,

im new to Qlik and couldnt find a solution in the Forum to my Problem yet.

I would like to see the number of the Day in a month

For example: 03.04.2018 is shown as 3 (european timestamp)

Im currently using the DayNumberofQuarter function

but what i want is basicly a DayNumberofMonth function which doesnt seem to exist.

Im glad for any help. 

Im using the autocalendar btw. in case i Need a mastercalendar please let me know!

2 Solutions

Accepted Solutions
shiveshsingh
Master
Master

=Day(Date)

 

This will work. You can also try a master calendar

View solution in original post

raman_rastogi
Partner
Partner

Hi Phillippr

Try Day () function

 refer qlik help for more functions details.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

 

Regards

Raman

View solution in original post

2 Replies
shiveshsingh
Master
Master

=Day(Date)

 

This will work. You can also try a master calendar

View solution in original post

raman_rastogi
Partner
Partner

Hi Phillippr

Try Day () function

 refer qlik help for more functions details.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

 

Regards

Raman

View solution in original post