Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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