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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to understand my expression that compute my stock amount ?

Hi All

I have this expression few year back from Sunny , it work fine. But i don't understand how this exprssion compute the right result.
Hope some one can share with me.

(RangeSum(Above(RangeSum
(Above(
Sum
(
{
<
year, month, sTOCK={sTOCK}
>
}
[Amount]), 0, RowNo()))),
-
Sum(
{
<
sTOCK={sTOCK}>
}
TOTAL Aggr(Sum(
{
<
year, month, sTOCK={sTOCK}
>
}
[Amount]), YearMonth
))))

 

 

1 Reply
paulyeo11
Master
Master
Author

Hi All

Enclosed my QVW