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 2016 bar divide by 4 instead of 12 ?

Hi All

I have a chart expression from sunny which is working fine on my GL stand alone table, using below expression :-


Money(
Sum(Aggr(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))), (YearMonth, (NUMERIC, DESCENDING))))/Count(distinct YearMonth)
, $(vMoneyFormatK_GL))

I try to using the same expression for my another QV doc , it display wrong value on 2016 bar.

May i know how to make it display as 1,373,000 ? ( Ref to Table 1 if add up 2016 jan till April amount divide by 4 = 1,373,000)

Now it display 457,799 because it all up 2016 stock and divide by 12. which is wrong.

it should be divide by 4. May i know how where to change ?


I will enclosed my QS Doc in my next posting.

Paul

2 Replies
paulyeo11
Valued Contributor II

Re: How to make 2016 bar divide by 4 instead of 12 ?

my QVF

paulyeo11
Valued Contributor II

Re: How to make 2016 bar divide by 4 instead of 12 ?

Hi All

eDIT :- I notice some thing very interesting , when i manually filter GL_CODE = 50010 , the 2016 bar become okay. why ? ( But when i not select GL_CODE =50010 the 2016 become wrong )