Skip to main content
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.