This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
Can we sort the order in the backend before loading?
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
LOAD * INLINE [
DROP Table Temp;
How will this inline change the sort order for the dimension, as we are dropping the inline table?
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.