Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adjusting formula 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.

21 Replies
sunny_talwar

What happens when you add more than 2? Can you show a screenshot with 3 and explain what the issue is?

OmarBenSalem

what if u try :

aggr(

rangesum(above(

sum([Actual Sales])

,0,rowno())

,(YearMonth,(Numeric,Ascend)), SubZone)

sunny_talwar

Did you mean this Omar

aggr(

rangesum(above(

sum([Actual Sales])

,0,rowno())

,SubZone, (YearMonth,(Numeric,Ascend)))

OmarBenSalem

Sure !

Anonymous
Not applicable
Author

Hello,

this is what it happens if choose more than two sub zones.

Capture.PNG

You see here for BBGR France the values are not the same comparing to first figure.

Thanks.

Alâa Eddine.

sunny_talwar

Can't really compare because the period selection is different within the two screenshots

Capture.PNG

Anonymous
Not applicable
Author

Hello,

i applied the formula and i have an issue:

Capture.PNG

Thank you for your help.

Alâa Eddine.

sunny_talwar

Are you using QlikView 12 or above? If you are, then ignore the error and click okay to see what you get

Anonymous
Not applicable
Author

Hello,

thank you i have QlikView 11.

Alâa Eddine.