topic Re: COUNT: Error in Expression in QlikView

COUNT: Error in Expression

jmarinesc — Tue, 04 Dec 2012 16:08:44 GMT

Hi!

I need to count Fieldn..only if field1 =-2 and field2 <> -1 and field3 <> -1 and field4 <> -1 ...then I get Error in expression..Tk in advanced.

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

JMC

Re: COUNT: Error in Expression

Tue, 04 Dec 2012 16:27:53 GMT

Try this

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

Re: COUNT: Error in Expression

MayilVahanan — Tue, 04 Dec 2012 16:30:05 GMT

Try like this

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

Hope it helps

Re: COUNT: Error in Expression

jmarinesc — Tue, 04 Dec 2012 18:04:01 GMT

Hello: This is an ex. The result must be 444 and these expr are counting something else...Tks.

Fieldn	Field1	Field2	Field3	Field4
222	-2	-1	-1	-1
222	-2		-1	-1
222	-2			-1
222	-2	-1	-1
222	-2	-1
222	-2		-1
222	-2	-1		-1
222	-2
222	-2
444

Re: COUNT: Error in Expression

jmarinesc — Tue, 04 Dec 2012 18:06:33 GMT

Sorry ....The result must be 2 I am using count not sum

Re: COUNT: Error in Expression

MayilVahanan — Tue, 04 Dec 2012 18:10:14 GMT

Try

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

Edit:

PFA

Hope it helps

Re: COUNT: Error in Expression

jmarinesc — Tue, 04 Dec 2012 18:51:24 GMT

Mayil;

If I use this expr: I got 0

COUNT({<ESSIMATCH={'-2'} ,ESNOMATCH-={'-1'} ,ESNOMATCH1-={'-1'} ,ESNOMATCH2-={'-1'}>}ESremision)

If I use below one: I got Partially my count but is including all registers that contains (-2) in field ESSIMATCH and I need only (-2) in ESSIMATCH and blanks or nulls in other fields.

count({<ESNOMATCH={''}>+< ESNOMATCH1={''}>+<ESNOMATCH2={''}>+<ESSIMATCH={'-2'}>} ESremision)

Re: COUNT: Error in Expression

MayilVahanan — Tue, 04 Dec 2012 19:03:00 GMT

Did u check the demo, its work fine for me. Can u post a sample data in csv or sample post?

for include the null value alone, u can use like this

{<ESNOMATCH-={'*'}>}

Hope it helps

Re: COUNT: Error in Expression

jmarinesc — Wed, 05 Dec 2012 00:03:10 GMT

Mayil;

I have been checked your demo already and it works fine....

but with my expr..doesn´t work.

How can I attach some data that I am using? , Tk in advanced!

COUNT ({<ESSIMATCH={'-2'} ,ESNOMATCH-={'-1'} ,ESNOMATCH1-={'-1'} ,ESNOMATCH2-={'-1'}>}ESremision)

JMC

Re: COUNT: Error in Expression

jmarinesc — Wed, 05 Dec 2012 16:18:34 GMT

Mayil;

I have been attached my QVW....Tk in adv.