Addition & Subtraction on Qlik Frontend table

[samuel_lin]

Hi all,

I have a table:

MODIFIED_MONTH	count({<EMAIL_PERMISSION_STATUS_={'I'} >} distinct RIID_)	count({<EMAIL_PERMISSION_STATUS_={'O'} >} distinct RIID_)
Nov 2012	168	0
Dec 2012	67,108	2,524
Jan 2013	3,998	2,184
Feb 2013	2,247	1,999
Mar 2013	2,083	1,731
Apr 2013	2,164	1,918
May 2013	1,944	1,430
Jun 2013	2,679	1,778
Jul 2013	2,442	1,288
Aug 2013	1,921	1,717
Sep 2013	2,022	2,209
Oct 2013	2,048	1,881
Nov 2013	2,090	1,764
Dec 2013	1,866	1,555

the second column is the count of "opt-ins" and the third column is the number of "opt-outs"

I would like to add one additional column to calculate the "Total Optins" overtime, which would be "Previous Optins + Current Optins - Current Optouts". Can that be possibly done in the front end? or any idea for the backend?

Thanks,

Samuel

[kaushiknsolanki]

Hi,

You can use the above function to get the previous value from the chart.

Below are some useful links.

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/ChartFunctions/InterRecordFunctions/abo...

The Above Function

Regards,

Kaushik Solanki

[nitin_01]

Hi Samuel,

This might help you :

                                    =RangeSum(Above(expression,0,RowNo()))-Above(expression,0)

Regards,

Nitin.