Qlik Community

New to Qlik Sense

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
prashant8837
Contributor II
Contributor II

Subtraction of Months From Given Months

24 Rolling Months from

last month of data

 

From Maximum month - 24 months.

 

 

Labels (2)
2 Solutions

Accepted Solutions
Thiago_Justen_

Hi there

You could try this: AddMonths(Max(DateField), -24).

The output will be a date. Then, you can format it as well as you need.

🤘🔥🚀

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

View solution in original post

prashant8837
Contributor II
Contributor II
Author

prashant8837_0-1645963441803.png

Addmonth is not working.

View solution in original post

4 Replies
Thiago_Justen_

Hi there

You could try this: AddMonths(Max(DateField), -24).

The output will be a date. Then, you can format it as well as you need.

🤘🔥🚀

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
prashant8837
Contributor II
Contributor II
Author

prashant8837_0-1645963441803.png

Addmonth is not working.

Thiago_Justen_

My fault. I forgot the "s". The function is AddMonths.

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
prashant8837
Contributor II
Contributor II
Author

Thanks Brother It worked Perfectly.