Expresion not Include (an easy one)

[#1]

Hi everybody!

I have a problem with my expression

I want to count some products when the type is PEND but not when the type is FACT.

Product	Type
1	FACT
2	FACT
3	PEND
1	PEND
4	PEND

In this example The result must be 2, becahuse of products 3 and 4. The thing is that product 1 should not be count because it is FACT too.

I feel it is simple but I can do it myself,

Thanks in advance!

[#2]

jajajajajajajaajajaja !!!!!!!!

YEESSSSSSS

I was writing FACT instead of Fact.

You are the best one !!! and I am the worst one !

Thanks, thanks, thanks a lot !!!!!

[sunny_talwar]

Awesome

If you got what you were looking for, do you mind closing this thread down by marking correct and helpful answers

Qlik Community Tip: Marking Replies as Correct or Helpful

[#4]

I have a problem with the user I create this Issue, that is why I am using this other user.

I really want to help you closing this, but I do not know how to reset my password, the mail for reseting is not been  sending. I receive the others mails, but not the one for reseting the user I use to create this issue.

Is there any way I can close it or reset the password ?

[sunny_talwar]

I think you can try to recover it by contacting Qlik: http://www.qlik.com/support

[swuehl]

For non-technical issues like login / password related issues, contact Qoncierge service:

qoncierge@qlik.com; ‎

[#7]

I will !!!

Thanks