topic Re: Calculations within a Table in QlikView

Calculations within a Table

Simba — Tue, 16 Jul 2019 08:56:37 GMT

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.

Re: Calculations within a Table

jsingh71 — Tue, 16 Jul 2019 09:19:56 GMT

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.

Re: Calculations within a Table

Simba — Tue, 16 Jul 2019 09:41:21 GMT

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!

Re: Calculations within a Table

Simba — Tue, 16 Jul 2019 09:43:34 GMT

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

Re: Calculations within a Table

jsingh71 — Wed, 17 Jul 2019 09:10:02 GMT

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.

Re: Calculations within a Table

Brett_Bleess — Wed, 07 Aug 2019 21:53:00 GMT

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_EditExpression.htm

Regards,
Brett