Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
please find attached this table.
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.
What happens when you add more than 2? Can you show a screenshot with 3 and explain what the issue is?
what if u try :
aggr(
rangesum(above(
sum([Actual Sales])
,0,rowno())
,(YearMonth,(Numeric,Ascend)), SubZone)
Did you mean this Omar
aggr(
rangesum(above(
sum([Actual Sales])
,0,rowno())
,SubZone, (YearMonth,(Numeric,Ascend)))
Sure !
Hello,
this is what it happens if choose more than two sub zones.
You see here for BBGR France the values are not the same comparing to first figure.
Thanks.
Alâa Eddine.
Can't really compare because the period selection is different within the two screenshots
Hello,
i applied the formula and i have an issue:
Thank you for your help.
Alâa Eddine.
Are you using QlikView 12 or above? If you are, then ignore the error and click okay to see what you get
Hello,
thank you i have QlikView 11.
Alâa Eddine.