Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
alaeddinekacem
Contributor II
Contributor II

Adjusting formulas to be generic

Hello,

please find attached this table.

Capture.PNG

I have an issue please help to check.

In the table i want to calculate the cumul sales and i noticed it works by using this formula

RangeSum(Above(TOTAL ([Actual Sales]), 0, RowNo(TOTAL))) but if i want to see many sub zones  more than two let's say 10 sub zones the formula does not work correctly.

So can you adjust the formula in order to get correct values even i wawnt to see many sub zones at the same time?

Just another note the formula works correctly with many sub zones for only january and february and then it works incorrectly.

Thank you for helping me.

Alâa Eddine.

1 Reply
sunny_talwar