Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Simba
Contributor
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.

 ABCDE
1 TotalSuccessesSR%Effect
2Jeremy23834.8%-3.0%
3Boris884348.9%-5.0%
4Tony6583.3%1.2%
5Sadiq453066.7%5.2%
6Total1628653.1%-

 

In Excel, this does the trick:

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

Thanks a lot for any help.

5 Replies
jsingh71
Partner - Specialist
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.

Simba
Contributor
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!

Simba
Contributor
Contributor
Author

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

jsingh71
Partner - Specialist
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.

Brett_Bleess
Former Employee
Former 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.