Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
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