Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How add GL_CODE=50010 , into SET expression

Hi All

My i know how to add GL_CODE=50010 , into below expression :-


Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month>}[Amount]*1), 0, RowNo()))),
-Sum(TOTAL Aggr(Sum({<year, month>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))

Paul

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Money(RangeSum(

Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),

-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))

, $(vMoneyFormatK_GL))

View solution in original post

2 Replies
paulyeo11
Master
Master
Author

My QVF file

sunny_talwar

May be this:

Money(RangeSum(

Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),

-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))

, $(vMoneyFormatK_GL))