variable days from previous month

[gz]

I need a variable that will show me a range of days from last month, the same as elapsed in the current month -1. Today it should be 1.03-23.03, Tomorrow 1.03-24.03

[vikasmahajan]

Hi

you can use like this:

You'll need to add something like this:

vPreviousYearMonth = {$(=Year(addmonths(max(Data),-1)))}

vPreviousmonth = Month(AddMonths(DateFull,-1))

=Sum({$<Year = {'=$(vPreviousYearMonth )'}, MonthName = {'=$(vPreviousmonth)'}>} Actual)

[gz]

I need this year previous month

[vikasmahajan]

Hi,

Please try this :

Previous month

Month(AddMonths(Today(),-1))

Previous Year

Year(AddMonths(Today(),-1))

Current Month

Month(Today())

Current Year

Year(Today())

[vikasmahajan]

https://community.qlik.com/t5/New-to-Qlik-Sense/Last-year-and-Previous-Month-Calculation/td-p/153072...

[gz]

 I count how many days have passed Today()-(monthstart(Today())) , then I need this quantity to mark this number of days (24) as 1.03.2023-24.03.2023

ok, I have start date from previous month 

monthstart(vPreviousMonthYear,) 01.03.2023

and end 

Date(monthstart(vPreviousMonthYear,)+(Today()-(monthstart(Today())))-1)

Then I need Sum