How to do cumulative sum for two dimension

[Anonymous]

Hi,

I would like to ventilate this   calculation "=sum({$<FlagOuvertFerme={'Ouverture'}>}CompteurTicket)- sum({$<FlagOuvertFerme={'Fermeture'}>}CompteurTicket)" on two dimensions  "month- year" and "status"

When i use on dimension  "month-year" and full accumulation  it's work

but when  i inserted  dimension of status,  it's not good, numbers are different

Can you help me?

Thank you

[sunny_talwar]

May be try this with no accumulation selected:

=RangeSum(Above(TOTAL Sum({$<FlagOuvertFerme={'Ouverture'}>}CompteurTicket)- sum({$<FlagOuvertFerme={'Fermeture'}>}CompteurTicket), 0, RowNo(TOTAL)))

[Anonymous]

thank you for your help but  it doesn't work figures are wrong whitout accumulation selected

[sunny_talwar]

Would you be able to provide a sample to look at?

[Anonymous]

Here is the file

thank you very much

[sunny_talwar]

I think your issue is that some of the statut are missing dates.

If those were 0 or null, it could have a still worked. The issue is that they are missing. Read here for difference between missing value and null: NULL handling in QlikView

Once you fix this issue, your chart should be fixed.

Best,

Sunny

[Anonymous]

Hi,

You were right, I did a test on an Exel file by creating null data on the missing status and it worked. So, I have to create null data in the model it will be difficile. Anyway thank you for your help

Best,

Boubker

[Anonymous · Accepted solution]

Hi,

Just to tell you I finalize your solution and it works thank you again for your help

best Boubker

[sunny_talwar]

Awesome

I am glad you finally made it to work.

Best,

Sunny

[rprios90]

Hello,
A cordial greeting,

I'm experiencing the same problem, do you think you can share the solution?