QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Creator III

Range Sum

Hi All,

I am trying to calculate the sum using the prior number which is aggregated by CDE and DimensionA.

Now I am trying to calculate cumulative observations, which is

A Completeness 25000

A Validity           26000 (25000+1000)

A Accuracy        26500.(25000+1000+500)

I got this using the expression:

RangeSum(Above(Total aggr(sum([Ruleset Failing Records]),[Associated DQ Dimension]CDE Name]),0,RowNo()) .

When I select Accuracy I get 500, instead of 26500.

Can anyone cme across this situation?

Message was edited by: Varun Reddy

1 Solution

Accepted Solutions
MVP

You used a sort expression which needed to be fixed as well

Match(Only({1}[DQ Dimesnion]), 'Completeness', 'Validity', 'Accuracy')

45 Replies
Anonymous
Not applicable

try:

if( not isnull(Dimension),

RangeSum(Above(Total aggr(sum({1} [Ruleset Failing Records]),[Associated DQ Dimension]CDE Name]),0,RowNo())

)

Creator III
Author

Hi Robin,

Thanks or quick response. This is not working.

Anonymous
Not applicable

is your dimension really called "Dimension" or is it just a label?

Creator III
Author

Associated DQ Dimension

Anonymous
Not applicable

then try:

if( not isnull([DQ Dimension]),

RangeSum(Above(Total aggr(sum({1} [Ruleset Failing Records]),[Associated DQ Dimension]CDE Name]),0,RowNo())

)

MVP

May be this

RangeSum(Above(Sum({<[Associated DQ Dimension]>}[Ruleset Failing Records]), 0, RowNo()) * Avg(1)

or this

Aggr(RangeSum(Above(Sum({<[Associated DQ Dimension]>}[Ruleset Failing Records]), 0, RowNo()), [Associated DQ Dimension], [CDE Name])

Creator III
Author

Robin,

I tested by replacing Dimension with [Associated DQ Dimension]. But it is not working.

Thanks,

VK

Anonymous
Not applicable

if Sunny's proposal doesn't work, please post a sample...

Creator III
Author

Hi Sunny,

Thanks for your response. But it didn't work.

This is my data:

This is my o/p:

Expression USed:

RangeSum(Above(Total aggr(sum( Failed),[DQ Dimesnion],CDE),0,RowNo()))