Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnu123
Creator
Creator

I want to find Last day of every Month closing balance

Hello Everyone,

I am having a one scenario like finding a every month last date closing balance.

Using Month year as a Dimension.

Using  Date  field need to find Last date Closing balance  for every month.

 

Can anyone help me to find some solution for this.

 

Thanks,

Chinnu.

1 Reply
MayilVahanan

Hi @chinnu123 

Try like below
Sum({<Date={"=Date=DayName(MonthEnd(Date))"}>}YourExpfield)
-- above will give month end date info.

Sum({<Date={$(=chr(39)&Concat(Aggr(Max(Date),MonthYear),chr(39)&','&chr(39))&chr(39))}>}YourExpfield)

- Above will give max date of that particular month.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.