calculate cumulative amount in 1 table qlikview

[marcvw]

Hi All, 

We have one table in qlikview and I need to calculate the cumulative values of 4 columns. See example below. 

As variables we have employee number and period. 

We are only able to modify expressions, we are not able to change the scripts. 

Is this possible in qlikview? Appreciate your support in here. 

Employee number	Total Gross	Total Deduction	Total Taxes	Net Pay		Gross Cumulative	Deduction Cumulative	Taxes Cumulative	Net payment Cumulative
1	2883.05	7.82	457.78	2373.01		2883.05	7.82	457.78	2373.01
1	3125.89	7.14	457.93	2623.69		3125.89	14.96	915.71	4996.7
1	3556.95	7.14	194.93	2712.79		3556.95	22.1	1110.64	7709.49
2	4975.82	22.44	3.21	3047.89		4975.82	22.44	3.21	3047.89
2	5205.69	20.53	3.64	3299.80		5205.69	42.97	6.85	6347.69
2	6104.75	20.53	564.28	3625.05		6104.75	63.5	571.13	9972.74
3	3094.50	8.90	441.20	2492.85		3094.50	8.90	441.20	2492.85
3	3094.50	8.90	441.36	2492.85		3094.50	17.8	882.56	4985.7
3	3336.35	8.13	441.53	2743.62		3336.35	25.93	1324.09	7729.32
3	4055.41	8.13	65.79	2978.04		4055.41	34.06	1389.88	10707.36
4	0.00	0.00	0.90	0.00		0.00	0.00	0.90	0.00
5	0.00	0.00	0.18	0.00		0.00	0.00	0.18	0.00
6	10172.78	0.00	805.74	7540.35		10172.78	0.00	805.74	7540.35
6	4182.36	22.12	340.76	3470.43		4182.36	22.12	1146.5	11010.78

[TcnCunha_M · Accepted solution]

Hello

try to use TOTAL in your expression:

ie.: Sum ( total Sales)
https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/defin...

[vinieme12 · Accepted solution]

which column are you referring to exactly? and what logic are you trying to implement ?can you describe the problem a bit more briefly please?

[marcvw]

Good day Vineeth, 

The columns that are named 'cumulative' needs to be calculated. 

Qlikview is utilized as a dashboarding only tool in an application, therefore we are not able to run/modify any scrpts and the only modifications we can perform is via expressions (to our knowledge). 

We have been able to perform a calculation for one column however if we would like to utilize similar formula, for the other columns, it's not functioning.

Therefore we are seeking for other potential solutions. Hope this helps.

Appreciate your support in here. 

Cheers, Marc

[TcnCunha_M]

Does total solve your problem?