Rangesum cumulative with 2 dimensions

[reivax31]

HI Qlikers,

I'm bulding a chart with cumulative sum and 2 dimensions. I found a lot of usefull informations on Qlik Community but I'm not completely finish with my task.

So I have a table with 3 dimensions. ID, Country, Month. So in my line chart I want to count my ID for each Country and do a cumulative sum for each month. So far I have this expression:

RangeSum(above(TOTAL Count(ID),0,RowNo(TOTAL)))

But my country are not treated individualy. How can I specify that I want only a rangesum for each country?

Thanks for your help

[sunny_talwar]

Awesome, I am glad it worked, but I advice you to convert your text field into a dual field for Month. May be not now, but you will def. be benefit from converting it down the line

Why don’t my dates work?

Get the Dates Right