topic Re: Count if Value only appears once in QlikView

Count if Value only appears once

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

Hello,

I need to Count values in one column but only if the value appears once. As well as values which appear more then once and how many duplicates.

9002216

9002217

9002218

9002219

e.g.

values appearing once: 3

values appearing more than once: 1

duplicates appearing: 3

Thanks for helping

sunny_talwar — Mon, 25 Sep 2017 12:20:24 GMT

Value appearing one

Count(DISTINCT{<Value = {"=Count(Value) = 1"}>}Value)

Value appearing more than once

Count(DISTINCT {<Value = {"=Count(Value) > 1"}>}Value)

Duplicate appearing

Count({<Value = {"=Count(Value) > 1"}>}Value)

jamesehunt — Fri, 29 Sep 2017 12:51:27 GMT

Hello Sunny,

thank you very much.

Would anyone be so kind and help me with the following :

sum full pallets if value appearing more than once

sumd full pallets if value appearing only once

Thank you very much for your help

sunny_talwar — Fri, 29 Sep 2017 15:41:11 GMT

May be this

sumd full pallets if value appearing only once

Sum({<Value = {"=Count(Value) = 1"}>} [full pallets])

sum full pallets if value appearing more than once

Sum({<Value = {"=Count(Value) > 1"}>} [full pallets])

jamesehunt — Mon, 09 Oct 2017 06:46:14 GMT

Thank you. Worked perfectly