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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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
MVP
MVP

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