Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Check this.
Rangesum cumulative with 2 dimensions | Qlik Community
If doesnt help share your application.
Regards,
Kaushik Solanki
Hi Solanki,
I tried this but it's not working:
=aggr( rangesum(above( sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), 0, rowno() )), CurrencyIsoCode, Month)
Marked in bold are my 2 dim.
Thanks,
As
maybe try
rangesum(aggr(above(total sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), 0, rowno(total)), CurrencyIsoCode, Month))
Sorry Kush not working.
Attached is sample.
Thanks,
AS
try this
rangesum(above(total sum(aggr(sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), CurrencyIsoCode, Month))/1000000,1,RowNo(TOTAL)))
Sorry not working!
Thanks,
AS
What is the output you are expecting to see here? You have UP2GO_2F... and Month as your dimensions, but you aggregating on CurrencyIsoCode and Month? Can you provide what the output needs to look like in numerical terms
Hi Sunny,
Current :
But Output should be like below Stage values on Bar
Month | Stage |
Jan | $51.35 |
Feb | $53.88 |
Mar | $132.70 |
Apr | $200.48 |
May | $202.90 |
Jun | $327.13 |
Jul | $487.90 |
Aug | $580.32 |
Sep | $733.42 |
Oct | $993.76 |
Nov | $1,014.90 |
Dec | $1,163.88 |
Thanks,
AS
Sorry This is Current Senario:
And Output in above is comment is required.
Thanks,
AS