Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Count a set of numbers with and exclusion

Hello,

I am counting how many cells contain > 80% but also want to exclude any that contain 100%. This is what I have which works but I have to add the fact of not counting the 100% in that set of data.

Count({<[UMHC SYSTEM]={'>0.8'},[EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16

Thanks for your help in advance!

1 Solution

Accepted Solutions

Re: Count a set of numbers with and exclusion

May be this

Count({<[UMHC SYSTEM]={">0.8<1"}, [EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16

2 Replies

Re: Count a set of numbers with and exclusion

May be this

Count({<[UMHC SYSTEM]={">0.8<1"}, [EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16

hammermill21
Contributor II

Re: Count a set of numbers with and exclusion

Well, that was a dumb mistake! LOL

Thanks Sunny!

Community Browser