What's the equivalent of Count() in QlikView?

[jessbanaga]

In SQL Server, script below counts if data exists with conditions. I want to know how it is done in Set Analysis.

IF (SELECT Count(*) FROM Customer WHERE CustomerType IN ('10','25,'50') > 1)

       SET BackColor = 'Blue'

ELSE

      SET BackColor = 'Red'

[tresesco · Accepted solution]

Try like:

Count({<CustomerType={'10','25,'50'}>}CustomerType)

[Anil_Babu_Samineni · Accepted solution]

Perhaps this

If(Count({<CustomerType={'10','25,'50'}>}CustomerType)>1, Blue(), Red())