Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
harsha
Creator
Creator

set analysis with Sum

Hello Experts,

this is my data and i'm trying to have multiple accuracy gauge charts based on diff fields.

 

I have taken this expression  "(Sum(Sample)-sum(Errors))/Sum(Sample)" to get total accuracy. 

however, I want to show where "Domain" is K360. 

What is the set analysis expression to achieve this? pls help

Guage.png

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

Try this

(Sum({<[IQM Domain] = {'K360'}>} Sample) - Sum({<[IQM Domain] = {'K360'}>} Errors))/Sum({<[IQM Domain] = {'K360'}>} Sample)

View solution in original post

2 Replies
sunny_talwar

Try this

(Sum({<[IQM Domain] = {'K360'}>} Sample) - Sum({<[IQM Domain] = {'K360'}>} Errors))/Sum({<[IQM Domain] = {'K360'}>} Sample)
harsha
Creator
Creator
Author

Hi Sunny...

thanks... it worked... appreciate your quick response