Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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...
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?
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...
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?
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
Does total solve your problem?