topic Count If Question in QlikView

Count If Question

Tue, 05 Jun 2012 07:00:19 GMT

Hello again,

a small Question this time:

I have an table with Employee, Customer ID, Date of visit and a Column "X". Looks like this:

Employee - Customer ID - Date of Visit - X

hhhhh 676762 01.06.2012 +

jjjjjj 586566 02.06.2012. -

....

The Column "X" contains +, -, K or P. In a straight table i want to add an calculated field that counts the "+" or "-"....(One customer can have more than 1 visits).

My Question: How the formula looks like to count for every Customer the amounts of "+", "-"?

Thank you for your help

Re: Count If Question

Miguel_Angel_Baeyens — Tue, 05 Jun 2012 07:29:34 GMT

Hi,

Did you try using set analysis? In a new chart, type straight table, the dimension should be Customer ID, and the expression something like

Count({< X = {'+'} >} [Customer ID])

Count({< X = {'-'} >} [Customer ID])

Hope that helps.

Miguel

Count If Question

Tue, 05 Jun 2012 07:39:51 GMT

Hello,

unfortunately it doesnt work for me. Your formula gives me only "1" as a value. But in my table are 13 "+" values for this customer. The fornula should show me the value 13 for this customer.

Kristian

Re: Count If Question

Miguel_Angel_Baeyens — Tue, 05 Jun 2012 07:49:05 GMT

Hi,

Try instead

Count({< X = {'+'} >} X)

Hope that helps now.

Miguel

Count If Question

Tue, 05 Jun 2012 08:00:38 GMT

Thank you a lot.