Calculations within a Table

[Simba]

Apologies, no doubt a very easy answer to this.

New to QlikView, basic experience with Excel.

Questions is: How can I replicate the formula in the EFFECT column in a QlikView table.

	A	B	C	D	E
1		Total	Successes	SR%	Effect
2	Jeremy	23	8	34.8%	-3.0%
3	Boris	88	43	48.9%	-5.0%
4	Tony	6	5	83.3%	1.2%
5	Sadiq	45	30	66.7%	5.2%
6	Total	162	86	53.1%	-

In Excel, this does the trick:

=(D$6-(C$6-C2)/(B$6-B2))

Thanks a lot for any help.

[jsingh71]

Hi,

Can you let me what fields are required to calculate the 'Effect' column. Instead of  this (D$6-(C$6-C2)/(B$6-B2)), if you can update the fields so I can write the expression for you.

[Simba]

Hey - thanks for the help!

The formula was written in Excel format, with the columns and rows as they appear in the table. So:

B= Total
C= Successes
D = SR%

The numbers correspond to the rows.

Does that help? Apologies - super new to Qlikview.

Thanks!

[Simba]

Sorry - one other thing. The formula in my original post was in cell E2 of that table.

[jsingh71]

Try this

(Sum(total SR%) - (Sum(total Successes) - Successes)) / (Sum(total Total) - Sum(Total))

If this will not work then provide the proper logic to calculate Effect.

[Brett_Bleess]

Did Jairaj's post help you resolve things?  If so, please be sure to give credit by clicking the Accept as Solution button to let others know this was the correct solution.  If you are still having issues, check the following link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Ajax/WebView_Ed...

Regards,
Brett