topic Re: Count in set Analysis in QlikView

Count in set Analysis

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

Hi all i want to count only of 1 value in a column.i have a dispute column in my table which it consists of 10lack rows .the data is like 0,1 in this column.now i want to count only 1 values in that 10 lakh records.

Re: Count in set Analysis

sunny_talwar — Tue, 02 May 2017 15:17:36 GMT

Why do you need set analysis if the values are 0s and 1s, may be just this

Sum(Dispute)

Re: Count in set Analysis

dathathreya — Tue, 02 May 2017 15:23:05 GMT

can u please give me a set analysis expression.

Re: Count in set Analysis

sunny_talwar — Tue, 02 May 2017 15:24:01 GMT

May be like this

Count({<Dispute = {1}>} Dispute)

Re: Count in set Analysis

Anonymous — Wed, 03 May 2017 07:50:30 GMT

Hi Sunny,

But in the above case, we can also use Sum(Dispute) which u mentioned earlier. Right ?. Because , however sum() will sum only '1' by ignoring '0'. If I am wrong, please correct me.

Re: Count in set Analysis

MindaugasBacius — Wed, 03 May 2017 08:00:34 GMT

Use as stalwar1 suggested Sum(Dispute) as this consumes less resources and is a more simple than Set Analysis.

Re: Count in set Analysis

dathathreya — Wed, 03 May 2017 09:38:21 GMT

How to achive MOM with this?Please help

Re: Count in set Analysis

Anil_Babu_Samineni — Wed, 03 May 2017 09:41:37 GMT

Still you are facing issue? Can you tell us what kind of challenge you are expecting? Would you provide sample data set and tell us expected result

Re: Count in set Analysis

dathathreya — Wed, 03 May 2017 17:21:07 GMT

Hi anil i got solution for that thanks for your support .

Re: Count in set Analysis

Anil_Babu_Samineni — Thu, 04 May 2017 02:00:48 GMT

So, Then please close this thread by flag Correct Answer of your spot light answer which you feel