topic Re: Expresion not Include (an easy one) in QlikView

Expresion not Include (an easy one)

Mon, 22 Feb 2016 20:26:48 GMT

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!

Re: Expresion not Include (an easy one)

sunny_talwar — Mon, 22 Feb 2016 21:05:44 GMT

May be this:

Count(DISTINCT {<Product = e({<Type = {'Fact'}>})>}Product)

Re: Expresion not Include (an easy one)

swuehl — Mon, 22 Feb 2016 21:28:16 GMT

Or when you need to filter on Type = PEND and there are more than these two types shown:

Count(DISTINCT {<Product = e({<Type = {'FACT'}>}), Type = {'PEND'}>} Product)

Re: Expresion not Include (an easy one)

Wed, 24 Feb 2016 00:52:06 GMT

The solution you gave me is very helpfull in the example I submit.

The problem is that I have one more condition that is not working.

Product	Type	Va
1	FACT	0
2	FACT	1
3	PEND	1
1	PEND	1
4	PEND	1
5	PEND	0
5	FACT	1

I am trying to filter only values where Va = 1 and then to count the PRODUCTS for PEND but not for FACT, only PEND.
In this case the solution is 3 (because the products 3,1 and 4)

I really do not know to work with the expression. Please Help me!

Re: Expresion not Include (an easy one)

sunny_talwar — Wed, 24 Feb 2016 10:48:18 GMT

Try this:

Count(DISTINCT {<Product = e({<Type = {'Fact'}>}), Va = {1}>}Product)

=Count(DISTINCT {<Product = e({<Type = {'Fact'}, Va = {1}>}), Va = {1}>}Product)

Re: Expresion not Include (an easy one)

Wed, 24 Feb 2016 12:28:42 GMT

Hi Sunny !

Thanks a lot for your help. You are been verry helpfull.

I understand what you do, and it works for me in the example I gave you. But it is not working on my aplication.

Can you please see it? It is making me go crazy.

The example is the same , but the fiels have differents names. SKU is a Product and se_Cumple is Va.
Now i am working with NODO =91, and I know that we have 292 SKU for PEND and 414 SKU for FACT.

Only 5 SKU and ind PEND but not in FACT, this are: 552495, 572637, 572639, 575806, 583366

The graph I am working is showing nothing now. I clear the board so it will be very easy for you to see how it is working.

I really need you help, please!

Re: Expresion not Include (an easy one)

sunny_talwar — Wed, 24 Feb 2016 13:22:07 GMT

I don't see a graph in your application? Can you guide me where to locate it?

Re: Expresion not Include (an easy one)

Wed, 24 Feb 2016 13:27:25 GMT

sure !!!
Please let me know if you can see ir. the problem is that with my expression there is nothing to show !

Re: Expresion not Include (an easy one)

Wed, 24 Feb 2016 15:21:29 GMT

I am not sure if you receive my answer because I see a message "Actually modarated" or something like that beacuse i see it in spanish.

I try this way too:

the problem is that with my expression there is nothing to show !

Let me know if you see the picture and the graph .

Thanks a lot!!!

Re: Expresion not Include (an easy one)

sunny_talwar — Wed, 24 Feb 2016 17:19:16 GMT

This?

Re: Expresion not Include (an easy one)

Wed, 24 Feb 2016 17:44:08 GMT

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 !!!!!

Re: Expresion not Include (an easy one)

sunny_talwar — Wed, 24 Feb 2016 17:53:18 GMT

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

Re: Expresion not Include (an easy one)

Wed, 24 Feb 2016 17:57:28 GMT

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 ?

Re: Expresion not Include (an easy one)

sunny_talwar — Wed, 24 Feb 2016 18:31:39 GMT

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

Re: Expresion not Include (an easy one)

swuehl — Wed, 24 Feb 2016 18:38:21 GMT

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

qoncierge@qlik.com; ‎

Re: Expresion not Include (an easy one)

Wed, 24 Feb 2016 18:59:38 GMT

I will !!!

Thanks