Qlik Community

Qlik Sense App Development

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

paulyeo11
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
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
paulyeo11
Valued Contributor II

Re: How to compute GL CODE from 50055 till 50057

my QVF

MVP
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))