# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for
Did you mean:
Contributor

## Calculations within a Table

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.

5 Replies
Partner - Specialist

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.

Contributor
Author

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!

Contributor
Author

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

Partner - Specialist

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.

Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.