# Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Valued Contributor II

## How to compute GL CODE from 50055 till 50057

Hi All

I try :-

>=50055 and <=50057

into below expression :-

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

it return zero.

Paul

1 Solution

Accepted Solutions
MVP

## Re: How to compute GL CODE from 50055 till 50057

Try this:

Money(RangeSum(

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

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

, \$(vMoneyFormatK_GL))

2 Replies
Valued Contributor II

my QVF

MVP

## Re: How to compute GL CODE from 50055 till 50057

Try this:

Money(RangeSum(

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

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

, \$(vMoneyFormatK_GL))