# Qlik Sense App Development

Valued Contributor II

## How to Combine GL_CODE 50057 & 50053 ?

Hi All

I have below work fine :-

GL_CODE = {50057}

Because i need to add one more number , so i try :-

GL_CODE = {50057}&{50053}

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

it does not work.

Paul

1 Solution

Accepted Solutions
MVP

## Re: How to Combine GL_CODE 50057 & 50053 ?

May be this:

Money(RangeSum(

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

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

, \$(vMoneyFormatK_GL))

2 Replies
Valued Contributor II

my QVF

MVP

## Re: How to Combine GL_CODE 50057 & 50053 ?

May be this:

Money(RangeSum(

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

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

, \$(vMoneyFormatK_GL))