5 Replies Latest reply: Dec 5, 2012 4:22 PM by Jaime Marines

Expr ´OK´ But not works for me...

```
```

Hello !

I am using:

Count ({<Field1={'-2'},Field2-={'-1'},Field3-={´-1´},Field4-={'-1'}>}Fieldn)

Expr is ´OK´ but I don´t get my result, I get (0) and It must be (5) in One Field

Attached My Ex1.qvw

• Re: Expr ´OK´ But not works for me...

Is this what you're looking for?

COUNT ({<Field1={'-1'} ,Field2={'-1'} ,Field3={'-1'} ,Field4={'-2'}>}Fieldn)

• Re: Expr ´OK´ But not works for me...

Hello;

No, I need to count Fieldn only (if : Field4 ={'-2'} and Field1, Field2, Field3 not equal to {'-1'} or equal to {'-'})

Regards

JMC

• Re: Expr ´OK´ But not works for me...
```Hello! QViewComm

```

If I try With INLINE data: It works, but not with (Load QVD or Load Xlsx) Attached Ex2.qvw

Expr:        COUNT ({<Field1-={'-1'} ,Field2-={'-1'} ,Field3-={'-1'} ,Field4={'-2'}>}Fieldn)

Fieldn, Field1, Field2, Field3, Field4

1789,-,-1,-1,-2

1790,-,-1,-1,-2

1791,-,-1,-1,-2

201006021,-,-1,-1,-2

201006021,-,-1,-1, -2

1790,-,-,-1,-2

201006011,-,-,-,-1,-2

201006011,-,-,-,-1,-2

201006023,-,-,-,-1,-2

201006023,-,-,-,-1,-2

1789,-,-1,-1,-2

1592380.1,-,-, -1,-2

1592381.1,-,-,-1,-2

1592382.1,-,-,-1,-2

1592383.1,-,-,-1,-2

1521600,-,-,-,-2

1521601,-,-,-,-2

1521602,-,-,-,-2

1521722,-,-,-,-2

1521723,-,-,-,-2

20720003,-,-,-1,-

20720004,-,-,-1,-

20720005,-,-,-1,-

20720006,-,-,-1,-

20720007,-,-,-1,-

20882087,-,-,-1,-

20882088,-,-,-1,-

20882089,-,-,-1,-

20882090,-,-,-1,-

20882091,-,-,-1,-

1047610946,-1,-1,-1,-2

1047610950,-1,-1,-1,-2

LTO1006102ET001,-1,-1,-1,-2

MEX1006101ED001,-1,-1,-1,-2

TIJ1006102ET001,-1,-1,-1,-2

];

But with:

Test:

FROM

It Doesn´t work.

Tk Tk Tk

• Re: Expr ´OK´ But not works for me...

No, I need to count Fieldn only (if : Field4 ={'-2'} and Field1, Field2, Field3 not equal to {'-1'} or equal to {'-'})

The count of that is 0. There are no records where Field1 has another value than -1 or null. Same for Field2 and Field3.

If you want the count of items where Field4= -2 and Field1,Field2 and Field3 are null, try this:

COUNT({<Field4={'-2'}>-<Field1={'*'}>-<Field2={'*'}>-<Field3={'*'}>} Fieldn)

• Re: Expr ´OK´ But not works for me...

Gysbert!!!

It works!      Thanks a lot!   I appreciate it!

JMC