Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
daisy1438
Contributor III
Contributor III

help me on below problem with gauge chart?

Hi

I am creating gauge chart and  writing below expression.

count(distinct {<[ Effectiveness1]={'Effective'},"Risk Status"={'Approved'}>}[Control ID])/count(distinct {<"Risk Status"={'Approved'}>} [Control ID])

It showing some % value.

and my filter is effective and ineffective .if select ineffective it showing  zero % and same time some value display. How to remove the value.

Thanks

0 Replies