Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression for no of days in a last 3 months

hi,

I want to write expression for no of days in a last 3 months from selected month and year.QlikTech Admin

1 Reply
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this

=Num(MonthEnd(Max(DateField), -1) - MonthStart(Max(DateField), -3))

Hope this helps you.

Regards,

Jagan.