Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

only count column where only criteria is matched

Hi

I have basically a room, and temperature of the room is taken at intervals in the day

Record ID Number    Date,               TestNumber,   HotCold

   1                         01/01/2015              1                 C

   1                         01/01/2015              1                 C

   1                         01/01/2015              1                 C

Record ID Number    Date,               TestNumber,   HotCold

   2                         02/01/2015              1                 C

   2                         02/01/2015              1                 C

   2                         02/01/2015              1                 C

Record ID Number    Date,               TestNumber,   HotCold

   3                         03/01/2015              1                 C

   2                         03/01/2015              1                 H

   3                         03/01/2015              1                 C

I wish to count only number of distinct Record ID Number, that have only recoded C for that day, in this case above 2

how can I amend the count expression to do this?

please help


1 Solution

Accepted Solutions
gompa786
Contributor III

Re: only count column where only criteria is matched

Hi

Please find attached QVF with expression Count({<HotCold={"C"}>}distinct([Record ID Number]))

and filter with Date..

Thanks

3 Replies
gompa786
Contributor III

Re: only count column where only criteria is matched

Hi

Please find attached QVF with expression Count({<HotCold={"C"}>}distinct([Record ID Number]))

and filter with Date..

Thanks

MVP
MVP

Re: only count column where only criteria is matched

What is the output that you expect to see?

joeybird
Contributor II

Re: only count column where only criteria is matched

thank you x