Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
samuel_lin
Not applicable

Addition & Subtraction on Qlik Frontend table

Hi all,

I have a table:

 

MODIFIED_MONTHcount({<EMAIL_PERMISSION_STATUS_={'I'} >} distinct RIID_)count({<EMAIL_PERMISSION_STATUS_={'O'} >} distinct RIID_)
Nov 20121680
Dec 201267,1082,524
Jan 20133,9982,184
Feb 20132,2471,999
Mar 20132,0831,731
Apr 20132,1641,918
May 20131,9441,430
Jun 20132,6791,778
Jul 20132,4421,288
Aug 20131,9211,717
Sep 20132,0222,209
Oct 20132,0481,881
Nov 20132,0901,764
Dec 20131,8661,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

Tags (1)
2 Replies
kaushik_solanki
Not applicable

Re: Addition & Subtraction on Qlik Frontend table

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

Re: Addition & Subtraction on Qlik Frontend table

Hi Samuel,

This might help you :

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

Regards,

Nitin.