Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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

45 Replies
varunreddy
Creator III
Creator III
Author

Can we sort the order in the backend before loading?

sunny_talwar

Sure you can....

If these 3 are the only values that would ever show in DQ Dimension. Add an inline load after environmental variables but before anything else in your script

Environmental Variables....

Temp:

LOAD * INLINE [

DQ Dimesnion

Completeness

Validity

Accuracy

];

Other script....

DROP Table Temp;

varunreddy
Creator III
Creator III
Author

How will this inline change the sort order for the dimension, as we are dropping the inline table?

sunny_talwar

Its just creating a sort order... once DQ Dimension comes in, it will pick that same sort order.... and later you don't really need the dummy table because you have transferred the sort order to your actual DQ Dimension.

varunreddy
Creator III
Creator III
Author

Cool, Thanks

navaskhan
Contributor III
Contributor III

RangeSum(Above(Total Sum(Failed),0Row(Total))