topic Re: Dont count a value from a different column in QlikView

Dont count a value from a different column

peterderrington — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created an expression to determine a compliance rate on my dashboard but i now need to be able to exclude specific rows with a given value from a different column......

Current expression is:

Count({<Place={'09'},[Questions Complete]={'Yes'}>}Place)/Count({<Place={'09'}>}Place)

This gives me the percentage of times that things in "Place" "9" have an answer of "Yes".

I need it to NOT count rows whereby the column 'There' has a value of "example"

Any suggestions?

To make things more complex, sometimes there will be two values in 'There' that i want it to exclude.

Thanks,

Peter

Re: Dont count a value from a different column

sunny_talwar — Mon, 22 Oct 2018 15:10:43 GMT

This needs to be excluded in just the numerator or both numerator and denominator? Try this

If just numerator

Count({<Place={'09'},[Questions Complete]={'Yes'}, Thing -= {'example'}>}Place)/Count({<Place={'09'}>}Place)

If both

Count({<Place={'09'},[Questions Complete]={'Yes'}, Thing -= {'example'}>}Place)/Count({<Place={'09'}, Thing -= {'example'}>}Place)

For multiple exclusions

Count({<Place={'09'},[Questions Complete]={'Yes'}, Thing -= {'example', 'anotherexample'}>}Place)/Count({<Place={'09'}, Thing -= {'example', 'anotherexample'}>}Place)

Re: Dont count a value from a different column

dplr-rn — Mon, 22 Oct 2018 15:15:20 GMT

use There-={'Example','Example1'}

Re: Dont count a value from a different column

peterderrington — Tue, 23 Oct 2018 08:41:00 GMT

Absolutely fabulous, thank you so much, that's sorted it perfectly.