Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
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?

Thanks in advance!

Message was edited by: Varun Reddy

1 Solution

Accepted Solutions
sunny_talwar

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

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


Capture.PNG

View solution in original post

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

)

varunreddy
Creator III
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?

varunreddy
Creator III
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())

)

sunny_talwar

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

varunreddy
Creator III
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...

varunreddy
Creator III
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()))