Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count number of days in previous month

Dear Friends

I need to calculate number of days of previous month.

For example:  If selected month is May , then it should return number of days in April, ie 30.

Below correctly gives number of days for current month. But I need previous month.

num(Monthend(max(DATE_OF_ISSUE)) -Monthstart(min([DATE_OF_ISSUE])))



Kindly help. Thanks in advance.



Regards

Chintan

14 Replies
sunny_talwar

I believe so...

vinieme12
Champion III
Champion III

yes

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Thanks a lot all Kamal.  Vineeth and Sunny , I think this will serve my purpose !!  

kamal_sanguri
Specialist
Specialist

Hi,

yeah, the data was updated but document was not reloaded with the corrected data.. Here is the updated one.. looking fine to me.. just in case if that still can help

Anonymous
Not applicable
Author

Sure Kamal , I will check. It can be helpful as it will work dynamically.

Other expression is static as today() is used.