Rangesum() in running total Help.

[aniketsr]

Hi Team,

Iam using rangesum and above function and plotting running total against (ID,Year,month).

Consider we have Year as 2015 and 2016.

If we select both the years the running total against the month is coming perfect,

But once i select 2016 the running total get affected as the rows get reduced for 2016.

i'am using the below expression :

=RangeSum(Above(TOTAL Sum({<MONTH=,YEAR=>}Amount),0,12))

Can someone guide me for an expression which should give static result against the respective month even after we select 2016.

Thank You.

Scripting‌

QlikView App Development‌

New to QlikView‌

[aniketsr]

Hi Sunny,

Attached is the sample application.

[aniketsr]

Hi Tresesco,

Attached is the sample copy

[tresesco]

Try removing TOTAL from your expression like:

Sum(aggr(rangesum(above( sum({<Month=,Year=>}Actual),0,12)),ID,Year,Month))

[sunny_talwar]

Is this what you are looking for? Even when you select 2015 or 2016, the rolling 12 month expression stays intact?

If not, then I think it would be helpful for you to point out the result you are expecting to see.

[aniketsr]

Hi Sunny,

i have uploaded the sample wherein i calculate the rolling 12 months , but when i select 2016&2015 the rolling 12 month

functions properly.On the other hand when i select 2016 the rolling 12 month functionality does not work.

Please guide me on the issue

Thanks,

[aniketsr]

Hi Tresesco,

thanks for the help i tried but did not work

i have uploaded the sample wherein i calculate the rolling 12 months , but when i select 2016&2015 the rolling 12 month

functions properly.On the other hand when i select 2016 the rolling 12 month functionality does not work.

Please guide me on the issue

[sunny_talwar]

Aniket - I am still not sure what you are looking for brother The only thing I see different when I select 2016 is that I only see the rows where Year is 2016. Is this what your issue is? You want to continue seeing 2015 and 2016 even when a single year is selected? I am not seeing any other issue with what you have (unless I am missing something here)

[aniketsr]

Hi sunny,

Ok i will explain properly

the running total changes after the year changes in the attached sample i want to have the rolling sum on the ID.

But if i select any month or year the straight table should get reduced to that Year and month respectively and the running total should be the same

Example:for R7918 the running sum should not initiate again to 15801 which is nothing but the actual number for jan'16 but it should be the Sum of feb-15 to jan'16 and on selecting 2016 the value in running 12 should be the sum of feb'15 to jan'16.

Thanks

[sunny_talwar]

Do you have QV12? If you do, checkout the attached file. this isn't perfect, but let's see if we are moving in the right direction

[aniketsr]

Hi,

Yes I do have QV 12 but there is no value in the "Actual Numerator Rolling 12" Column.