Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
dandaanilreddy
Partner - Creator III
Partner - Creator III

Range sum issue

Hello Qlik developers,

I'm trying to create the no's below in red using the below expressions but my no's are not giving me the below output in red. I have written the same expressions for one of the table which is giving me the expected results. Can someone help me on this please?

Final: if(column(1) >0 and (isnull(fabs(above(column(1)))) or isnull(fabs(below(column(1))))), Column(1))

Base: IF((isnull(Above([VALUE])) OR ISNULL(BELOW([VALUE]))),NULL(),RangeSum (Above([VALUE],0,9)))

 

 

GroupSub GroupValueIncreaseDecreaseFinalBase
TestA75  75 
TestB-10 10 65
TestC-15 15 50
TestD55  55
TestE-8 8 47
Test1F44  51
Test1G66  57
Test1H-13 13 44
Test1ZZZ74  74 

 

Thanks

1 Solution

Accepted Solutions
MayilVahanan

hi

Try like below

IF((isnull(Above(Total [Value])) OR ISNULL(BELOW(Total [Value]))),NULL(),RangeSum (Above(Total [Value],0,9)))

MayilVahanan_0-1629270615455.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

6 Replies
Saravanan_Desingh

Try this,

tab1:
LOAD *, If(Match([Sub Group],'A','ZZZ'), Value) As Final,
	If(Not Match([Sub Group],'A','ZZZ'), K1) As Base;
LOAD *, RangeSum(Peek(K1),Value) As K1;
LOAD * INLINE [
    Group, Sub Group, Value
    Test, A, 75
    Test, B, -10
    Test, C, -15
    Test, D, 5
    Test, E, -8
    Test1, F, 4
    Test1, G, 6
    Test1, H, -13
    Test1, ZZZ, 74
];

Drop Field K1;
Saravanan_Desingh

Output:

commQV83.PNG

dandaanilreddy
Partner - Creator III
Partner - Creator III
Author

Hi Saran,

Thank You for the response. I'm looking to achieve this on UI expression as my dimension values changes. 

Thanks

Glen320
Contributor
Contributor

I have also same error but can't find solution please reply if anyone know.

 

MyAARPMedicare

MayilVahanan

hi

Try like below

IF((isnull(Above(Total [Value])) OR ISNULL(BELOW(Total [Value]))),NULL(),RangeSum (Above(Total [Value],0,9)))

MayilVahanan_0-1629270615455.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
dandaanilreddy
Partner - Creator III
Partner - Creator III
Author

Hi MayiVahanan,

The expression worked. Thanks a lot. 😊

Thanks