Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jessbanaga
Contributor II
Contributor II

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

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'

2 Solutions

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

View solution in original post

Anil_Babu_Samineni

Perhaps this

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

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

Anil_Babu_Samineni

Perhaps this

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)