Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master
Master

Hi All

Enclosed my QVW