Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

range sum of object

Hello Everybody,

 

I need to do range for this object :

 

For example i have a bar char with these date , I need to do the sum of these object like in the photos (In 2021-03 i will have 46 (3+7+36) test.PNG

Thanks 

7 Replies
zied_ahmed1
Specialist
Specialist

Hello I have 2 dimensions i used this set analysis but in 2021-10 and 2021 the value is not ok : 

Aggr(
RangeSum(Above(
Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo()))
, Envirement, (Migration_date,NUMERIC, ASCENDING))

2.PNG

Any ideas please 

 

Chanty4u
Champion III
Champion III

try now

Aggr(RangeSum(Above(Count({$<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo())), Envirement, Migration_date,NUMERIC, ASCENDING)

zied_ahmed1
Specialist
Specialist

Thank you but it doesn't work 😕 

zied_ahmed1
Specialist
Specialist

Chanty4u
Champion III
Champion III

may be any one of it

Aggr(RangeSum(Above(Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo()))
, Envirement, (Migration_date,(NUMERIC), ASCENDING))

 

or

aggr(rangesum(above((Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name]),0,RowNo())),SecondDim,FirstDim)

zied_ahmed1
Specialist
Specialist

Thank you but it doesn't work with these two set analysis 

Chanty4u
Champion III
Champion III

can you attach sample? 

one sample i attached check that aswell