Cumulative Sum Help!

[amit_saini]

Hi Folks,

I need to cumulative sum on bar chart , below is my expression:

=num(Money(sum(aggr(sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), CurrencyIsoCode, Month))/1000000),'####')

I'm trying Something like below , but it's not working:

=aggr( rangesum(above( sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), 0, rowno() )), CurrencyIsoCode, Month)

Thanks,

AS

[amit_saini]

Sorry Sunny,

No still it's not working.

The moment you will select year , Cumulative sum gone . See below:

Thanks,

AS

[ramachandra_gee]

Hi Sunny,

I am facing some problems with the complex section access.

the requirement is mentioned in the below.

please guide me if you have any idea.

input.

site	state	disitnct	sales
India	ap	ongole	80
India	ap	nell	85
india	bhp	paradise	23
india	bhp	cellorium	45
us	remedy	calom	86
us	remedy	siral	75
kenada	kalosa	richel	66
kenada	kalosa	silaj	89
kenada	sumera	aparlak	25
non-south	pradesh	kilkut	36
non-south	pradesh	suraj	25

output for admin.

site	state	disitnct	sales
India	ap	ongole	80
India	ap	nell	85
india	bhp	paradise	23
india	bhp	cellorium	45
us	remedy	calom	86
us	remedy	siral	75
kenada	kalosa	richel	66
kenada	kalosa	silaj	89
kenada	sumera	aparlak	25
non-south	pradesh	kilkut	36
non-south	pradesh	suraj	25

out put for who is having india access

site	state	disitnct	sales
India	ap	ongole	80
India	ap	nell	85
india	bhp	paradise	23
india	bhp	cellorium	45
site2	remedy	default	86
site2	remedy	default	75
site3	kalosa	default	66
site3	kalosa	default	89
site3	sumera	default	25
non-south	pradesh	kilkut	36
non-south	pradesh	suraj	25

out put for  who is having us access

site	state	disitnct	sales
site1	ap	default	80
site1	ap	default	85
site1	bhp	default	23
site1	bhp	default	45
us	remedy	calom	86
us	remedy	siral	75
site3	kalosa	default	66
site3	kalosa	default	89
site3	sumera	default	25
non-south	pradesh	kilkut	36
non-south

Thanks,

Ram,

9710463111

[sunny_talwar]

I guess you will need to fill the missing values

Generating Missing Data In QlikView

[amit_saini · Accepted solution]

Hi Sunny,

Thank You!

I already got solution to my problem.

This happens, when the second Dimension isn’t completely filled on each month. So with the AsOfTable concept which is explained very good under following link you can build up a nice solution which is easy to handle and give you much more flexibility.

https://community.qlik.com/docs/DOC-4252

Thanks,

AS