Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor III

(RangeSum(Above(RangeSum How to make able list all company ?

Hi All

Below expression from Mr Sunny working fine :-

money(

(RangeSum(Above(RangeSum

(Above(

Sum

(

{

<

year, month, $(ColumnDim801)={$(ColumnDim801)}

>

}

[Amount]/1000), 0, RowNo()))),

-

Sum(

{

<

$(ColumnDim801)={$(ColumnDim801)}>

}

TOTAL Aggr(Sum(

{

<

year, month, $(ColumnDim801)={$(ColumnDim801)}

>

}

[Amount]/1000), YearMonth

))))

, $(vMoneyFormatK))

But when i list all company , the result is wrong for SOURCE =ADL.

Remark :- for TDSS the value alway correct.

Any work around ?

Paul

1 Reply
paulyeo11
Valued Contributor III

Re: (RangeSum(Above(RangeSum How to make able list all company ?

my QV Doc