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 make sunny Expresssion with out RangeSum(Aboive ?

Hi All

I have this expression from Mr Sunny :-

RangeSum(

Above(RangeSum(Above(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1/1000)), 0, RowNo()))),

-Sum(TOTAL Aggr(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1/1000)), YearMonth)))

It work fine in QS , but not my QV ver 9. As i remember before , when i plot chart if i remove RangeSum(Above

the chart may able to give the correct value.

Hope some one can share with me how to remove the RangeSum(Above from above expression.

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: How to make sunny Expresssion with out RangeSum(Aboive ?

my QV Doc