topic Re: How to count with three conditions in QlikView

How to count with three conditions

Thu, 11 Apr 2013 22:09:30 GMT

ATENCIONXUSUARIO	Estado
User1	Cerrado
User2	Cerrado
User3	Cerrado
User1	Abierto
User2	Cerrado

In the table you can see the example, we have the two columns, in this case i need to count the elements in 'ATENCIONXUSUARIO' column for User 1 and User 2, when the column 'Estado' is "Cerrado", according to the example the result must be 3.

How can i do that???

Best Regards

Re: How to count with three conditions

Thu, 11 Apr 2013 22:23:36 GMT

Hi,

Try with this:

Count({< ATENCIONXUSUARIO={User1, User2} >} Estado)

If the result is different, try to include the DISTINCT Clause:

Count({< ATENCIONXUSUARIO={User1, User2} >} DISTINCT Estado)

Regards,

Ricardo

Re: How to count with three conditions

Thu, 11 Apr 2013 23:04:01 GMT

Thanks for your answer.

With the expression that you suggest we can only count the items that contains User1 and User2 in the column ATENCIONXUSUARIO, but we cant filter to in the column "Estado" the word Cerrado.

How can i do that?

Re: How to count with three conditions

kaushiknsolanki — Fri, 12 Apr 2013 12:57:20 GMT

Hi,

Try this.

Count({< ATENCIONXUSUARIO={User1, User2},Estado = {"Cerrado"} >} Estado)

Regards,

Kaushik Solanki