topic Re: Count function in QlikView

Count function

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

Hi Experts,

Can any one please help me on below requirement.

I have to calculate the count when Column A is not matching with Column B based on unique IDs.

Here for the XYZ ID Column A is not Matching with Column B. So i need to get the count as 1.

Thanks in advance

Re: Count function

PrashantSangle — Wed, 29 Nov 2017 12:43:35 GMT

In straight table try like simple if with count()

count(if(ColumnA<>ColumnB,1,0))

Regards,

Re: Count function

Anonymous — Wed, 29 Nov 2017 12:44:52 GMT

try this in script:

load
count(if(Hash128(product)<>Hash128(product1),Customer)) as newcustomercount
;
Load * inline [
Customer,product,product1
A,p1,p1
B,p2,p10
C,p3,p4
D,p5,p6
];

Re: Count function

tresB — Wed, 29 Nov 2017 12:45:14 GMT

May be like this?

Count({<ID={"=[Column A]<>[Column B]"}>}ID)

Re: Count function

Anil_Babu_Samineni — Wed, 29 Nov 2017 12:46:38 GMT

Rather, I would think much on this?

If(ColumnA <> ColumnB, 1,0) as Flag

Then, Count({<Flag = {1}>} ID)

Or direct forward

Count({<ColumnA = {"=ColumnA <> ColymnB"}>} ID)

Re: Count function

PrashantSangle — Wed, 29 Nov 2017 12:48:55 GMT

Yes you are correct.

I will go with tresesco‌ solution.

Regards,