Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cumulative

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

25 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

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
Not applicable
Author

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...

Capture.PNG

Anonymous
Not applicable
Author

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 guidePag 1.png

Page 2.png

sunny_talwar

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)

Capture.PNG

Capture.PNG

Anonymous
Not applicable
Author

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

Running KPI.png

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
Not applicable
Author

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!!