New to QlikView

Discussion board where members can get started with QlikView.

Contributor

How to do cumulative sum for two dimension

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

1 Solution

Accepted Solutions
Contributor

Re: How to do cumulative sum for two dimension

Hi,

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

best Boubker

12 Replies
MVP

Re: How to do cumulative sum for two dimension

May be try this with no accumulation selected:

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

Contributor

Re: How to do cumulative sum for two dimension

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

MVP

Re: How to do cumulative sum for two dimension

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

Contributor

Re: How to do cumulative sum for two dimension

Here is the file

thank you very much

MVP

Re: How to do cumulative sum for two dimension

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

Contributor

Re: How to do cumulative sum for two dimension

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

Contributor

Re: How to do cumulative sum for two dimension

Hi,

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

best Boubker

MVP

Awesome