Cumulative

[Anonymous]

Hello All

I need a urgent help.. Please help me in this scenario.

I am calculating the running total in visualization based on the months.

When I click on any particular month, the running total is failed.

Is there any way to fix the running total??

I tried to use {1} value to make them static but the issue with that I am not able to filter that value via different filters

Thanks!!

New to Qlik Sense‌

[sunny_talwar]

I think it should do what you are expecting. Can you share a sample where this isn't working?

[Anonymous]

Sir, I have the excel template for the data.

I want the running total on the basis of ACCID and can be filter out CIN,DIN & MAN.

I have created a pivot for better understanding.

Thanks!! !

Please guide

[sunny_talwar]

I meant a qvf sample where you can demonstrate its not working for you. I am extremely sorry, but I won't have time to create a sample from the data provided. If you can create a qvf file, I will be more than happy to look at it

[Anonymous]

Sure sir.. Sorry for that..

Please find the attached qvd file and excel file for your reference.

As per the requirement, I want that the Running Total becomes static and it provides the correct number if I filter on filters

Using {1} gives the incorrect numbers

Please guide

Thanks in advance!!

[sunny_talwar]

Working for me...

[Anonymous]

Thanks sir for all your help!!

Sir if we are using {1} in the formula, there is a issue in filtering CIN

Pag 1: Shows first table excludes {1} and second table includes {1} and it has no filter

For E.g. Apr 2014 we have RT = 9 both table

Page 2:

Shows first table excludes {1} and second table includes {1} and it has filter CIN

For E.g. Apr 2014 we have RT = 7 in first and RT = 9 in second

Thus with using {1} the data does not changes using Filters

Please guide

[sunny_talwar · Accepted solution]

1) You don't have to call me sir . My name is Sunny

2) I already gave you the option to use this expression

RangeSum(Above(Count({<Active_Month, Active_Date>}DISTINCT AccID), 0, RowNo())) * Avg(1)

[Anonymous]

Thanks Sunny for the help!!.

The formula works fine in the table. But if I am using it in the KPI and filter on any month. The KPI does not move at all. Can you please help me in this one also?.

In the below snap if I filter on Aug 2014, the running total is 21 but KPI becomes static (by using the above formula which works fine in table) and it is showing 31

Please suggest.

Thanks

DC

[sunny_talwar]

I won't use this RangeSum() expression for KPI. Just use simple set analysis to get the value your are looking to get. Please share QVF (not the QVD) if you need more help

[Anonymous]

Please find my attached QVF file.

It would be great for me if you tell me how to get the Running total via month

Thanks a lot Sunny for your time and help!!