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: 
paulyeo11
Master
Master

How to get last month Stock balance amount ?

Hi All

I have below expression can give me Stock Balance Amount for Max date :-

=Sum({$<date = {"<=$(=Max({$}[date]))"}, month = >}[Amount])

May i know how to modify the above , so that i can get last month Stock Balance Amount ? This will enable me to compare Current month stock vs last month.

Paul

0 Replies