Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

narenjln
Contributor

Test Result Column Percentage

Hi i am having the Test Result Column,In that column i am having the test Result as Pass,Fail,N/A

i need to get the overall execution percentage & also percentage based on pass ,Fail, N/A.

1 Solution

Accepted Solutions
karthikoffi27se
Contributor III

Re: Test Result Column Percentage

Hi Lakshmi,

Please use the below formula

Sum([Test Result])/Sum(Total[Test Result])


Many Thanks

Karthik

2 Replies
MVP
MVP

Re: Test Result Column Percentage

Would you be able to share a sample or some image to show what you have? Also, it might help to show the expression you use to calculate Pass, Fail, N/A

karthikoffi27se
Contributor III

Re: Test Result Column Percentage

Hi Lakshmi,

Please use the below formula

Sum([Test Result])/Sum(Total[Test Result])


Many Thanks

Karthik